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 “camelids” with Change Limit: [1] [2] [3] [4]

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

89 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
camelids135694(None) 
camelias12510301camelias
camelid1249411camelid_
camelia11510432cameli_a
camellias1365092camellias
camels105217082camel__s
capelins12311132capelins
abelias93213563_abelias
amends94713283_ame_nds
amids85627513_am__ids
amyloids1446003_amyloids
annelids946233annelids
bumelias1245063bumelias
cadelles1139973cadelles
cagelike1537723cagelike
cageling12310843cageling
cagelings1335413cagelings
caids85226423ca___ids
calends1039523cale_nds
califs114915893ca__lifs
camails11311753cam_ails
cambrics1645253cambrics
camel96822803camel___
cameleer1246033cameleer
cameleers1345093cameleers
camelhairs1751853camelhairs
camellia1255443camellia
camellike1745063camellike
cameoed1238383cameoed_
cameoing1379063cameoing
cameos105818003came__os
cameras11313363came_ras
cames97047313came___s
camisias12268603camisias
camlets114314623cam_lets
cammies134016483cam_mies
candids113812693ca_ndids
canellas10310563canellas
canids95118133ca__nids
capelans1238013capelans
capelets1268603capelets
capelin11510973capeli_n
caplins113515993ca_plins
capsids1239333ca_psids
carabids1338193carabids
careless102813633careless
carlins93921913ca_rlins
carotids11229943carotids
casefies1339213casefies
caseins93115053case_ins
caseloads1244283caseloads
catenoids1246433catenoids
catlins93818843ca_tlins
caulds95512383ca_ul_ds
caulis85320083ca_uli_s
cavelike1738213cavelike
cebids11439173c__ebids
cheloids1438033c_heloids
chields13507483chiel_ds
cicelies1269753cicelies
cichlids1643663cichlids
clerids1049093c_lerids
comedies13311843comedies
comelier12310653comelier
comeliest13410033comeliest
comelily1546693comelily
complies14314523complies
complins14313113complins
coverlids1544753coverlids
cymlins1436693cym_lins
eyelids1135943_eyelids
fameless13259203fameless
families1339443families
felids103111623__felids
gamelans11115843gamelans
gamelike1538033gamelike
halids104016133ha__lids
harelips1345213harelips
javelins18277733javelins
lameds94812033lame__ds
lamellas1098163lamellas
melds84822383__mel_ds
meloids10911453__meloids
nameless10248373nameless
ramekins1466113ramekins
ramilies10311833ramilies
ravelins113011603ravelins
tameins9311423tame_ins
tameless10259903tameless

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162897.14020470.9
3Display Results89890.0332697.0
 (SQL Overall)178691897.59323533.6
 
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.