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 forchoanae” 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.

130 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
choanae123685(None) 
choana1138431choana_
chance134617082ch_ance
change124116732ch_ange
cloacae1145222cloacae
cabana103913543cabana_
cabanas112412993cabanas
canal75428033c__anal
canape10913503c__anape
cane66653113c__an_e
canoe75627243c__anoe
carinae94318533carinae
catenae9311343catenae
cetane8315263cetan_e
chadar1239323ch_adar
chaetae1238573chaetae
chafe135117353ch_a_fe
chaine115119203ch_aine
chaise114916383ch_aise
chalah143511633ch_alah
chalazae2244413chalazae
chamade15138393ch_amade
chanced154113203ch_anced
chancel144011773ch_ancel
chancer144215603ch_ancer
chances145218053ch_ances
chancre14348753ch_ancre
chancy164010843ch_ancy
chang115418543ch_an_g
changed144214133ch_anged
changer134215513ch_anger
changes134517573ch_anges
changs125215353ch_angs
channel123910473ch_annel
chant105932683ch_an_t
chantage1446623ch_antage
chanted134015943ch_anted
chanter123919703ch_anter
chantey154112533ch_antey
chants115020383ch_ants
chanty145215813ch_anty
chape125221133ch_a_pe
charade13129853ch_arade
charas114223563ch_aras
chare105231953ch_a_re
charge125114203ch_arge
chase105127123ch_a_se
chasse115114603ch_asse
chaste114617353ch_aste
chazan20269123ch_azan
cheapie1437553cheapie
chelae113614583ch_elae
chianti1236603chianti
chicane1489533chican_e
china105022443ch_ina_
chinas115119363ch_inas
chine105231693ch_in_e
choice132010513cho_ice
choke145118023cho__ke
chola104718033cho_la_
cholas114817963cho_las
cholate122114893cholate
choline122915333choline
cholla113911023cholla_
chollas123811323chollas
chon96627793cho_n__
choose115116113cho_ose
chopine143512233chopine
choral115118473cho_ral
chorale124313333chorale
chordal13449833chordal
chordate1448023chordate
chore105126763cho__re
chorea115216073chorea_
choreal124412193choreal
choreas124414153choreas
chorial124214123chorial
chorine123218313chorine
chortle124210443chortle
chose105925403cho__se
chouse116017563cho_use
chowse144711753cho_wse
chutnee1246823chutnee
cicadae1244853cicadae
cleanse9358723cleanse
cloaca1037263cloaca_
cloacal1135123cloacal
cloacas1136223cloacas
clonal8310903clo_nal
clone75728143clo_n_e
coala77521123c_oala_
coalas87418953c_oalas
coannex1635493c_oannex
coarse84813893c_oarse
coatee84327213c_oatee
coaxal15387293c_oaxal
cognac1157273c_ognac
cognate10312163c_ognate
cohune1189413cohun_e
coinage10310533c_oinage
comae97128413c_o_mae
comanage1346283comanage
cone67256963c_o_n_e
conge85227593c_o_nge
connate9315713c_onnate
conte76633193c_o_nte
cornea84018913c_ornea
coronae94214883coronae
costae85319683c_ostae
cottae84615703c_ottae
coxae146115183c_o_xae
crane75331593c_ran_e
crone75231323cro_n_e
cyanate12259703c_yanate
echidnae1442893echidnae
hance105424123_h_ance
hanse85722793_h_anse
hoagie10239983_hoagie
hoarse94411303_hoarse
honan85319763_ho_nan
hone77549323_ho_n_e
khanate1437053kh_anate
ochone11311273ocho_n_e
phonal11310373pho_nal
phonate12411793phonate
phone105621903pho_n_e
shone83725973sho_n_e
thanage11117903th_anage
thane86122533th_an_e
zonae145116433_zo_nae

Search took 6 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.1401276364.3
2DLD Change Limit1340271305.72023431.3
3Display Results1301300.0304333.3
 (SQL Overall)1786911305.89030338.0