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

116 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
celosia93946(None) 
celosias1048901celosias
celesta947642celesta
melodia1038882melodia
peloria9310952peloria
abrosia939273abrosia
aerobia939463aerobia
agnosia837643agnosia
allodia8128793allodia
alodia71112453_alodia
aplasia92510803aplasia
begonia1047213begonia
calesa8412473cales_a
caloric113413223caloric
calorie92716893calorie
calos74431903calos__
camisia112810243camisia
cassia83714763c_assia
ceboid11310653cebo_id
cecropia1455153cecropia
celeriac1246163celeriac
celestas1057083celestas
celeste949653celeste
celestial1146153celestial
celiac101910433cel__iac
cella75420313cel__la
celli76717693cel_li_
cellist9314423cellist
cellos84517803cellos__
cells75428063cells__
celom9515693celo__m
celomata1296633celomata
celoms10412123celo_ms
celotex1635023celotex
cels65534973cel_s__
celts75325783celts__
ceria75125353ce__ria
ceros74726073ceros__
cerotic11415063cerotic
cesta75419483ce__sta
cheloid13310833chelo_id
chelonian1454843chelonian
chloasma1542963chloasma
chloric143410613chloric
chlorid133211843chlorid
chlorin123113003chlorin
ciboria1147043ciboria
cilia73016763cil__ia
clivia1177233c_livia
cloaca1037263c_loaca
clonic104914673c_lonic
close76425223c_los_e
closed95317963c_losed
closer84918203c_loser
closes85425593c_loses
closet85226603c_loset
closing103114843c_losing
cobia94117513c__obia
coelomic1445713coelomic
coelostat1145673coelostat
colobi105011083colobi_
coloni85619203coloni_
colonial10411343colonial
colonic115015713colonic
colossal1045553colossal
colossi935673colossi
coria75828323c__oria
cosie74728263c__osie
costa75523733c__osta
cyclosis1547473cyclosis
deliria868303deliria
deposit10313003deposit
ecclesia1244103ecclesia
eclosion1046893eclosion
ectopia1147693ectopia
elodea738673_elodea
eloin55923203_elo_in
eluvia936133_eluvia
elysian1065083_elysian
enosis63816423_enosis
eosin55220923_e_osin
eulogia846663eulogia
felsic1147053fel_sic
gloria71910543_gloria
glossa7529163_glossa
helos84928063helos__
keloid11812623kelo_id
kenosis11369003kenosis
ketosis11429733ketosis
logia68116603__logia
meiosis939023meiosis
melisma1146473melisma
melodias1148703melodias
melodic1238543melodic
melodica1344983melodica
meloid9616003melo_id
meropia1149613meropia
oceloid1037973ocelo_id
pelorian1048883pelorian
pelorias10410593pelorias
peloric11310713peloric
pelota8612833pelo_ta
phelonia1347043phelonia
reposit9315863reposit
senopia949233senopia
serosa6313023seros_a
silesia739083silesia
telesis7310793telesis
telia55821143tel__ia
teloi54217383telo_i_
telomic1147603telomic
telos55424523telos__
tylosin1046903tylosin
valonia1048303valonia
velaria1038923velaria
xerosis14249663xerosis

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.406440125.6
2DLD Change Limit1340271166.81319672.2
3Display Results1161160.0303866.7
 (SQL Overall)1786911167.24924650.4
 
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.