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

158 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
dhurnas115344(None) 
dharnas1155371dharnas
dhurna1043561dhurna_
churns114910232churn_s
dharmas1356502dharmas
dharna1055262dharna_
dhourras1252232dhourras
diurnal844882diurnal
diurnals943802diurnals
douras75016722dour_as
duras65727722d_ur_as
durns64819862d_urn_s
durras74713372d_urras
anurans73810553anurans
anurias7312243anurias
auras55932553_aur_as
bournes93615023bournes
bourns84114063bourn_s
bunas75126573_bu_nas
burans85019303_burans
buras74736293_bur_as
burkas124513803_burkas
burns74926773_burn_s
burqas174410903_burqas
bursas85318273_bursas
charas114223593char_as
charkas164810953charkas
chinas115119383ch_inas
choreas124414203choreas
chufas14397673chu_fas
chukkas1532783chukkas
chunks154210333chu_nks
chuppas1644123chuppas
churls115411073chur_ls
churn105113103churn__
churned13358373churned
churner12298343churner
churners13316883churners
churros12427583churros
churrs115111513chur_rs
curns74924273_curn_s
darns66927893d_arn_s
daturas838763datur_as
daunts75014083dau_nts
dehorns11428363dehorn_s
dermas94116813d_ermas
dharma1276103dharma_
dhooras1135943dhooras
dhourra1152023dhourra_
dhurrie1153943dhurrie
dhurries1255583dhurries
dhutis1035923dhu_tis
diurons838823diurons
dobras94811913dobr_as
donas65926473d__onas
donnas75511323d_onnas
doulas75114993dou_las
doumas95314813dou_mas
doura66518663dour_a_
dourah10479813dour_ah
dourahs11487253dourahs
dourines9311363dourines
dourness947683dourness
drunks11427513dru_nks
duennas834143duennas
dulias71212743d_ulias
dumas85420433d_u_mas
dunam8313733d_u_nam
dunams937833d_u_nams
dunes65332173d_u_nes
dungs75821973d_u_ngs
dunks105621193d_u_nks
duns55140433d_u_n_s
dunts65828413d_u_nts
dura55232113d_ur_a_
dural64923893d_ur_al
durbar968723d_urbar
durbars1077973d_urbars
dures65635923d_ur_es
duress74712063d_uress
durian7312003d_urian
durians839573d_urians
durmast1037623d_urmast
durn56127623d_urn__
durned84113173d_urned
durocs9569703d_urocs
duros65422693d_ur_os
durra65315793d_urra_
durrs65519993d_ur_rs
durums948153d_urums
dysurias1244453dysurias
faunas94013633fau_nas
furans94515953_furans
hennas94211803_hennas
hernias10310773_hernias
herns84825583_hern_s
horas86333093_hor_as
horns86125333_horn_s
hulas84920883_hu_las
humans112312433_humans
hunks125321453_hu_nks
huns76136933_hu_n_s
hunts86826173_hu_nts
hurds95219073_hur_ds
hurls86522713_hur_ls
hurrah12369183_hurrah
hurrahs13336773_hurrahs
hurray12459913_hurray
hurrays13386153_hurrays
hursts97213093_hursts
hurts86922823_hur_ts
huzzas1735863_huzzas
hyenas1288953_hyenas
iguanas835373iguanas
inurns63310983inurn_s
journal1484963journal
journals1574353journals
journos14134943journos
kahunas1473953kahu_nas
korunas1135443korunas
kurtas10349883_kurtas
lauras63414333laur_as
lunas55025013_lu_nas
mourns84111013mourn_s
muras75329563_mur_as
murras84916003_murras
punas74826753_pu_nas
puranas9712643_puranas
purdas92612263_purdas
pyurias1236703pyurias
rhumbas14305163rhumbas
ruanas6311263_ruanas
saunas63915433sau_nas
sharias102516003sharias
sharns95516983sharn_s
sherpas1238093sherpas
shorans102812403shorans
shuns85018143shu_n_s
shunts95712013shu_nts
spurns84811383spurn_s
sunnas63914563_sunnas
suras55336323_sur_as
surras65919533_surras
thorias102312043thorias
thorns95314093thorn_s
thujas1634433thu_jas
thulias1035743thulias
thunks13459033thu_nks
thurls9418713thur_ls
thuyas1234773thu_yas
tunas54224123_tu_nas
turns55623233_turn_s
ulnas55716533__ulnas
ureas55826013__ureas
urns46323893__urn_s
varnas94212823_varnas
whenas124610463wh_enas
whereas13448903whereas

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 Limit1340271587.25018486.5
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.46923924.4
 
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.