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

234 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
dourahs1148725(None) 
dourah10479811dourah_
douras75016721doura_s
coprahs14338152coprahs
dobras94811912dobra_s
doughs115912932dou_ghs
doulas75114992doula_s
doumas95314812douma_s
doura66518662doura__
duras65727732d_ura_s
fourths13374952fourths
hoorahs13399612hoorahs
horahs126313872ho_rahs
houdahs1434242houdahs
surahs94515542_surahs
torahs95115642to_rahs
anurans73810553anurans
aoudads973763aoudads
auras55932563_aura_s
borals86721913bo_rals
boras75938303bo_ra_s
boughs125414373bou_ghs
bourgs9459993bour_gs
bournes93615023bournes
bourns84114063bour_ns
bourses94014303bourses
burans85019303_burans
buras74736303_bura_s
burghs12519923_burghs
cobras104014193cobra_s
coprah133710603coprah_
copras103517153copra_s
corals85325143co_rals
corrals93713853corrals
cougars1038443cougars
coughs125514543cou_ghs
courage10310993courage
courages11311393courages
courant9317973courant
courants10310803courants
courlans10117613courlans
courses94218893courses
courts84216173cour_ts
couths115715413cou_ths
curaghs1334583_curaghs
dahs88231813d___ahs
daturas838783datura_s
dearths11498843dearths
defrags1236193defrags
defrays1436113defrays
derats74625063d_erats
derays105514253d_erays
dhooras1135943dhoora_s
dhourras1252233dhourras
dhurnas1153443dhurnas
digraphs15105753digraphs
dirams94413703d_irams
diurnals943803diurnals
diurons838823diurons
doats65224883do__ats
doblas93812293dobla_s
dobra85013103dobra__
dobros93910233dobr_os
doers65225713doer__s
dogears937513dogears
dogmas105011243dogma_s
dognaps1134393dognaps
dollars83311023dollars
dolmans10479683dolmans
dolmas95213043dolma_s
donas65926473do_na_s
dongas84914613donga_s
donnas75511323donna_s
doodads1035093doodads
doormats1145413doormats
doors65022133door__s
doorways1544043doorways
dopas85019063do_pa_s
dorado838813do_rado
dorados938203do_rados
dories75232363do_ries
dorks105724443do_r_ks
dorms85723843do_r_ms
dorps85419223do_r_ps
dorrs65520593do_r_rs
dors56747603do_r__s
dorsals84110853dorsals
dossals8379303dossals
dotards937253dotards
doubles103113353doubles
doubts968733dou_bts
douche124613223dou_che
douches134315233douches
dough105217383dou_gh_
dought114915523dou_ght
doughy14499843dou_ghy
doula65717773doula__
douma85817703douma__
doums85417643dou__ms
dour56330433dour___
dourer74215273dour_er
dourest8312943dourest
dourine8311453dourine
dourines9311373dourines
dourly103210433dour_ly
dourness947683dourness
dousers84817273dousers
douses74928933dou_ses
dowries114413983dowries
drabs85119673d__rabs
drags75521113d__rags
drams86025833d__rams
drats66628373d__rats
draws95119373d__raws
drays95819773d__rays
drouths11436483drou_ths
duads76515343d_u_ads
duals65620083d_u_als
ducats95011763d_ucats
dumas85420433d_uma_s
dunams937833d_unams
dura55232113d_ura__
dural64923893d_ura_l
durbars1077973d_urbars
dures65635923d_ur_es
duress74712063d_uress
durians839573d_urians
durns64819873d_ur_ns
durocs9569703d_urocs
duros65422693d_ur_os
durras74713373d_urras
durrs65519993d_ur_rs
durums948153d_urums
forams115115913fo_rams
forays124813003fo_rays
fours85521493four__s
fourth12357443fourth_
furans94515953_furans
gerahs1039413_gerahs
goorals838713goorals
gorals76917653go_rals
goulash1164273goulash
gourami1083803gourami
gouramis1184163gouramis
gourdes9109383gourdes
gourds8108253gour_ds
hijrahs2043443hijrahs
hookahs17446663hookahs
hoorah124411113hoorah_
hoorays13418383hoorays
horah117922053ho_rah_
horas86333103ho_ra_s
houdah1335173houdah_
houris94514583hour_is
hours85422393hour__s
howdahs1733613howdahs
hurrahs13336773hurrahs
jarrahs1735453jarrahs
jorams154810533jo_rams
jouals1338933jou_als
journals1574353journals
journos14134943journos
jurats134213203_jurats
koras95927123ko_ra_s
korats105416063ko_rats
kouros1039183kour_os
lauras63414333laura_s
loofahs13364623loofahs
lorans65117603lo_rans
lotahs9479873lo_tahs
loughs105014773lou_ghs
loumas84812333louma_s
lours55125293lour__s
mollahs12328283mollahs
moolahs12347383moolahs
morals85324643mo_rals
moras76438783mo_ra_s
morass84614503mo_rass
morays114613883mo_rays
morphs13149433mo_rphs
mourns84111013mour_ns
mouths115214533mou_ths
murals84016763_murals
muras75329583_mura_s
norths96812323no_rths
nougats8427413nougats
nourish1039703nourish
obeahs1135863_obeahs
odahs95610083_o_dahs
odographs1667343odographs
odours7418253odour__s
okras94410973_okra_s
oompahs1434263oompahs
opahs105411983_o_pahs
orals55826483_o_rals
ouphs104311273_ou_phs
ourang73311063_ourang
ourangs8318503_ourangs
ourari63413543_ourari
ouraris73512933_ouraris
ours47237563_our__s
plurals936913plurals
pourers93513673pourers
pours74623183pour__s
pujahs18404943_pujahs
purdahs13285483_purdahs
roughs105416223rou_ghs
rouths95416823rou_ths
sirrahs10377303sirrahs
soras55041013so_ra_s
souaris7312333souaris
soucars938423soucars
soudans8309353soudans
soughs105115623sou_ghs
sources9312173sources
sourish10310693sourish
sours55230503sour__s
souths95216603sou_ths
sovrans1036483sovrans
subahs114512393_subahs
surah86823253_surah_
suras55336333_sura_s
torah87125273to_rah_
toras55540373to_ra_s
toucans937583toucans
toughs105414993tou_ghs
touraco945363touraco
touracos1045313touracos
tourers73512743tourers
tours55325893tour__s
vouvrays1741373vouvrays
worths127812893wo_rths
yours85217883your__s
youths124510043you_ths

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.470380193.6
2DLD Change Limit1340272347.07618941.1
3Display Results2342340.0802925.0
 (SQL Overall)1786912347.62623431.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.