Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “camise” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
camise10331963(None) 
camisa103114321camisa
camises114218461camises
chamise143612851chamise
amice96122872_amice
amide86128482_amide
amie66339852_ami_e
amies76837692_amies
amine75835382_amine
amis66445322_amis_
amiss75823072_amiss
amuse75920832_amuse
anise55129702_anise
arise56436432_arise
cadis84428502cadis_
camas96333522camas_
camases114216342camases
camass104114182camass
cambism1538032cambism
cambist13312112cambist
came87648752cam__e
cames97047312cames_
camion103917192camion
camisade1374822camisade
camisas113411922camisas
camisia112810242camisia
camisole1246172camisole
cammie124615292cammie
cammies134016482cammies
camos95927612camos_
camps116330262camps_
cams87047282cam_s_
canine83826702canine
caribe103416752caribe
caries85147622caries
carmine112918482carmine
carse74934332ca_rse
case65848082ca__se
cause75225352ca_use
cavie104621592cavi_e
cavies114525002cavies
cayuse11207762cayuse
cerise84822042cerise
chaise114916412chaise
chamisa14328852chamisa
chamises153513312chamises
chamiso14348652chamiso
chemise143211502chemise
comose105016852comose
cruise84314042cruise
cymose13429652cymose
demise94618322demise
famine114318192famine
famish14311842famish
gamine94620152gamine
lamiae84817452lamiae
mamie95826002mami_e
mamies104626242mamies
mise66043582__mise
paise75028332pa_ise
pavise114714802pavise
raise54828052ra_ise
ramie75027822rami_e
ramies84630462ramies
ramose8314402ramose
remise84221952remise
samisen937672samisen
samite83020602samite
tamis76728732tamis_
tamises92715972tamises
valise92917642valise
vamose1159282vamose

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.346516448.0
2DLD Change Limit82551722.53032628.9
3Display Results72720.0332181.8
 (SQL Overall)178691722.90961427.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.