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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 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
camelid124941(None) 
camelia11510431camelia
camelids1356941camelids
camel96822802camel__
camelias12510302camelias
camellia1255442camellia
camels105217082camel_s
cameoed1238382cameoed
capelin11510972capelin
abelia83114403_abelia
ambled115116373_ambled
amebic1239113_amebic
ameboid1277233_ameboid
amend85717753_ame_nd
amid77036353_am__id
amylic13108713_amylic
amyloid1348543_amyloid
aneled74719283_aneled
annelid838733annelid
atelic8313703_atelic
bumelia1145263bumelia
cabled114819873ca_bled
cackled164613303cackled
cactoid12311033cactoid
cadelle1039923cadelle
caged95426363cage__d
cagelike1537723cagelike
cageling12310843cageling
caid77837533ca___id
cajoled17428283cajoled
caked126128623cake__d
calif104929103ca__lif
calix145317353ca__lix
called94126733ca_lled
calmed114816383calme__d
camail10314833cam_ail
camailed1336553camailed
camails11311753camails
cambered15129003cambered
cambia124913153cam_bia
cambric1537383cambric
came87648753came___
cameleer1246033cameleer
camelhair1651953camelhair
camellias1365093camellias
camellike1745063camellike
cameo95924993came__o
cameoing1379063cameoing
cameos105818003came_os
camera10313693came_ra
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
cames97047313came__s
camisia112810243camisia
camlet104426583cam_let
camlets114314623camlets
cammie124615293cam_mie
camped134720233cam_ped
campi116217783cam_pi_
campily1638273campily
canaled103615563canaled
canceled13279403canceled
candid104517853ca_ndid
candled113815743candled
caned85838093cane__d
canella9310793canella
canid85526343ca__nid
caped104931803cape__d
capelan1139003capelan
capelet11517073capelet
capelins12311133capelins
capered123014043capered
caplin103216303ca_plin
capsid11312413ca_psid
carabid12311333carabid
cared86050093care__d
carlin84421823ca_rlin
caroled103717693caroled
caroli85918233caroli_
carotid102014833carotid
cased86032413case__d
casefied1445943casefied
caseic103212373case_ic
casein83216453case_in
caseload1145623caseload
castled104311513castled
catenoid1149113catenoid
catered103117773catered
catlin83819083ca_tlin
cauld85318443ca_ul_d
caulis85320083ca_ulis
caved116227563cave__d
cavelike1738213cavelike
caviled1348723caviled
cawed116627063cawe__d
cebid104314073c__ebid
cheloid13310833c_heloid
chield124610213chiel_d
cichlid1545313cichlid
clerid9312413c_lerid
comedic14158633comedic
comelier12310653comelier
comelily1546693comelily
comely134213733comel_y
cometic131215723cometic
complied1539673complied
complin13312073complin
coverlid1445943coverlid
creeled104012013creeled
cumuli1036273cumuli_
cupeled1257793cupeled
cymlin1337313cym_lin
cymoid1459473cym_oid
easeled8159853easeled
enameled1136373enameled
eyelid1038443_eyelid
famed115928343fame__d
famuli1136763famuli_
felid94717173__felid
gambled134112163gambled
gamed95126393game__d
gamelan10106643gamelan
gamelike1538033gamelike
gamely124711913gamel_y
gametic1239993gametic
gaveled12399133gaveled
gelid74916983__gelid
haemoid1337203haemoid
halid94424983ha__lid
hamuli1137063hamuli_
harelip1245953harelip
javelin17306983javelin
labeled102510563labeled
lamed85235293lame__d
lamella988613lamella
lamely114013223lamel_y
lapeled10258893lapeled
meld75830473__mel_d
melic94722333__melic
meloid9616003__meloid
named85223063name__d
namely113711323namel_y
pallid93915283pa_llid
paneled10612573paneled
rambled123913523rambled
ramekin13126493ramekin
ramilie9310283ramilie
raveled114113633raveled
ravelin102211023ravelin
sampled123410793sampled
tamed85528513tame__d
tamein8313093tame_in
tamely113711953tamel_y
trameled11309073trameled
valid94618393va__lid
wambled153610753wambled

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271576.59320328.7
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.04625360.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.