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 “celadon” 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.

114 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
celadon103691(None) 
celadons1137001celadons
claxon1536582c_laxon
telamon936522telamon
beacon10511373be_acon
belabor1136293belabor
belady12489933belad_y
belon73924113bel__on
blazon1736763_blazon
cajon144513903c__ajon
calando1037383calando_
caldron1038153caldron
calvados1444813calvados
canon74725303c__anon
capon95221873c__apon
cardon94120853c_ardon
cedarn9408443ceda_rn
celandine1245623celandine
cello74919583cel_lo_
cellos84517803cel_los
celom9515693cel__om
ceratin93020163ceratin
cession939813cession
chador1238673c_hador
chaldron1445773chaldron
chelation1439963chelation
chelator1347913chelator
clad76225823c_lad__
clade85821013c_lad_e
clades94920463c_lades
cladode1134613c_ladode
clads85722733c_lad_s
clamor1049453c_lamor
clan65633923c_la__n
clarion9311663c_larion
claro75018693c_laro_
claros84015113c_laros
classon937693c_lasson
claxons1635803c_laxons
clean75420413clea__n
clon66232483c_l__on
codon86522853c__odon
colon78630193col__on
cordon95017293c_ordon
craton84517193c_raton
crayon114110003c_rayon
cullion91910233cullion
dalapon1044893dalapon
deacon9510423de_acon
deaden83714323de_aden
decagon1135863decagon
delation92318083delation
delator83015023delator
elain55324703_ela_in
elan46734243_ela__n
elation73620453_elation
elevon977953_elevon
etalon648973_etalon
felon84619293fel__on
flacon1138633_flacon
flagon1037983_flagon
gelada837623gelad_a
geladas936313geladas
gelatin83514733gelatin
gelation93014433gelation
gelato73812953gelato_
gelatos83111513gelatos
helicon1237643helicon
hellion10311133hellion
hexagon1843823hexagon
kelson1038153kel_son
klaxon1733853_klaxon
laden65022193__laden
ladron73413323__ladron
lardon74415063__lardon
leaden74515223le_aden
meadow1237403me_adow
megaron10248303megaron
megaton10269853megaton
melanin9310893melanin
melodeon1143443melodeon
melon73922083mel__on
meltdown1442763meltdown
melton8311553mel_ton
menazon1846053menazon
methadon1444523methadon
negaton8299143negaton
nelson638423nel_son
paladin101011773paladin
pelon74423213pel__on
peloton938743peloton
polaron939843polaron
radon64620503__radon
readorn8310483re_adorn
reason62616333re_ason
redon65424883re__don
relation82619773relation
relator74016363relator
relaxin14239183relaxin
scalado10276473scalado_
scalados11276083scalados
seadog838743se_adog
season62714903se_ason
seladang1043403seladang
seldom939413sel_dom
selfdom1343733selfdom
telson6310293tel_son
tendon7312033te_ndon
unladen8248653unladen
velamen1237123velamen
weakon13357623we_akon
weapon11288113we_apon
weason93210823we_ason
weldor10317653wel_dor

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.410435831.7
2DLD Change Limit1340271146.84319586.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.29924481.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.