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 “conidia” 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
conidia106930(None) 
conidial1159501conidial
conidian1168381conidian
gonidia975901gonidia
cnida878952c_nid_a
coccidia1244002coccidia
comitia1139712comitia
conidium1366642conidium
ctenidia1143012ctenidia
gonidial1065942gonidial
gonidic1166102gonidic
oidia6314952_o_idia
accidia1246983accidia
aconitic1239523aconitic
aecidia1047273aecidia
ascidia1046673ascidia
basidia1047613basidia
bolivia1246063bolivia
bonita8312943boni_ta
camisia112810243camisia
candid104517853can_did
candida114110253candida
canid85526343canid__
canids95118133canid_s
canikin13189753canikin
cardia9916373c_ardia
cilia73016763c__ilia
clivia1177233c_livia
clonidine1286153clonidine
cnidae978143c_nidae
cobia94117513co__bia
coda77029343co__d_a
codeia94112183co_deia
codicil1246803codicil
coedit9316233co_edit
colicin11313743colicin
colitic112916183colitic
colitis92617343colitis
comedian1347453comedian
comedic14158633comedic
comitial1248693comitial
conceit113218073conceit
concha134213283con_cha
conchie143312683conchie
conciliar1345923conciliar
condign1147733condign
condo85322593con_d_o
condom114215363con_dom
condor94616963con_dor
condos94322333con_dos
conduit10713073conduit
coned86040053coned__
confide13310203confid_e
confided1537453confided
confider1438123confider
confides14310573confides
confiding1638333confiding
confit113316403con_fit
conga85419873con__ga
congii957363con_gii
coni65534803con__i_
conic95329793con__ic
conical11316203conical
conicity15411093conicity
conics103920593coni_cs
conies84338593coni_es
conifer123212643conifer
coniine9316803coniine
conin76232723con__in
conine84528553coni_ne
conines93827793conines
coning94331823coni_ng
conins84327233coni_ns
coniosis1048133coniosis
conium10415313coni_um
coniums11311863coniums
conjoin1638193conjoin
conoid9818883con_oid
conoidal1149003conoidal
conoids10813883conoid_s
conquian1945733conquian
consider11310393consider
contagia1156773contagia
contain9315823contain
continua1047653continua
contra83314693con_tra
convivial1764113convivial
cordial10312933co_rdial
coremia11310363coremia
coria75828303co__ria
corrida1078493corrid_a
cotidal1038453cotidal
cotinga10348023cotinga
coxitis16238453coxitis
cymbidia1842083cymbidia
gonadial1066823gonadial
gonadic1177213gonadic
gonia64117533gon__ia
gonidium1244213gonidium
honda9414983hon_d_a
monadic1268883monadic
monodic1269783monodic
nidi56524393__nidi_
nonideal947293nonideal
oxidic1635943_oxidic
peridia10312363peridia
podia8415283po__dia
pycnidia1642873pycnidia
pygidia1444193pygidia
pyxidia2043843pyxidia
scandia1038063scan_dia
solidi73813153solidi_
tolidin839243tolidin
tondi65716143ton_di_

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.1561145455.1
2DLD Change Limit1340271147.00019146.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.