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

355 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
dourah1047981(None) 
doura66518661doura_
dourahs11487251dourahs
douras75016721douras
coprah133710602coprah
dobra85013102dobra_
dobras94811912dobras
dough105217382dou_gh
doula65717772doula_
doulas75114992doulas
douma85817702douma_
doumas95314812doumas
dour56330432dour__
dourer74215272dourer
dourly103210432dourly
dura55232112d_ura_
dural64923892d_ural
duras65727722d_uras
fourth12357442fourth
hoorah124411112hoorah
horah117922042ho_rah
houdah1335172houdah
surah86823252_surah
torah87125272to_rah
anural65714743anural
anuran64313243anuran
aoudad835033aoudad
aura45836253_aura_
aurae54128113_aurae
aural54428963_aural
aurar54420253_aurar
auras55932553_auras
bora66141633bo_ra_
boral75831703bo_ral
boras75938303bo_ras
borax145918723bo_rax
bough115719313bou_gh
bourg84113843bour_g
bourgs9459993bourgs
bourn75518483bour_n
bourne83714093bourne
bourns84114063bourns
bourse84414333bourse
bura66139533_bura_
buran75225303_buran
buras74736293_buras
burgh115216033_burgh
church1636483church
cobra95214403cobra_
cobras104014193cobras
copra98115463copra_
coprahs14338153coprahs
copras103517153copras
coral76033453co_ral
corral83616253corral
couch125320113cou_ch
cougar958783cougar
cough115819643cou_gh
courage10310993courage
courant9317973courant
courlan9117763courlan
course85117773course
court75532763cour_t
courts84216163courts
couth106122483cou_th
crura7312583crura_
crural8610633crural
curagh1236553_curagh
curch124415413_curch
dah78148983d___ah
datura738023datura_
daturas838763daturas
dearth104212513dearth
defrag1136463defrag
defray1337643defray
derat65044083d_erat
deray95024183d_eray
dhoora1035653dhoora_
dhooras1135943dhooras
dhourra1152023dhourra
dhourras1252233dhourras
dhurna1043563dhurna
dhurnas1153443dhurnas
digraph14146633digraph
diram84419473d_iram
diurnal844883diurnal
diuron738573diuron
doat56947673do__at
dobla84913643dobla_
doblas93812293doblas
dobro84412213dobr_o
dobros93910233dobros
doer57734703doer__
doers65225713doer_s
doeth9411983do_eth
dogear838193dogear
dogma96112463dogma_
dogmas105011243dogmas
dognap1035343dognap
dollar74110983dollar
dolma86214173dolma_
dolman95312403dolman
dolmas95213043dolmas
domal85619203do_mal
dona55529633do_na_
donas65926473do_nas
donga76718423donga_
dongas84914613dongas
donna66215033donna_
donnas75511323donnas
doodad936423doodad
door56928513door__
doorman1037063doorman
doormat1059073doormat
doors65022133door_s
doorway1444243doorway
dopa77220903do_pa_
dopas85019063do_pas
dor47253923do_r__
dorado838813do_rado
dore56353303do_r_e
dork96531463do_r_k
dorks105724443do_rks
dorky135518743do_rky
dorm76834623do_r_m
dorms85723833do_rms
dormy115817463do_rmy
dorp76028053do_r_p
dorps85419223do_rps
dorr56627723do_r_r
dorrs65520593do_rrs
dors56747603do_r_s
dorsa64617283do_rsa
dorsad8408973dorsad
dorsal74613943dorsal
dorty96220813do_rty
dory85836233do_r_y
dossal75510303dossal
dotal64919623do_tal
dotard839053dotard
doth86225713do__th
double94013993double
doubly12328963doubly
doubt8720093dou_bt
doubts968733doubts
douce85518423dou_ce
douche124613223douche
doughs115912933doughs
dought114915513dought
doughy14499843doughy
doum76226673dou__m
doums85417643dou_ms
dourest8312943dourest
dourine8311443dourine
douse66329723dou_se
doused84821163doused
douser75621633douser
douses74928933douses
doux125817983dou__x
dovish1338103dovish
dowry126312483dowr_y
drab76226453d__rab
drag64825053d__rag
dram75832003d__ram
drat56247833d__rat
draw85623013d__raw
dray85428093d__ray
drouth104410103drou_th
duad66521413d_u_ad
dual55928173d_u_al
ducal84816423d_ucal
ducat86225903d_ucat
duh77930383d_u__h
duma75524453d_uma_
dumas85420433d_umas
dunam8313733d_unam
dunch115316263d_unch
durbar968723d_urbar
dure56341813d_ur_e
dured75025403d_ured
dures65635923d_ures
durian7312003d_urian
durn56127623d_ur_n
durns64819863d_urns
duro56228023d_ur_o
duroc84513143d_uroc
duros65422693d_uros
durr55624353d_ur_r
durra65315793d_urra
durras74713373durras
durrs65519993d_urrs
durst66125173d_urst
durum8513203d_urum
dutch114713823d_utch
fora75937393fo_ra_
foram105124933fo_ram
foray115023973fo_ray
forth116222673fo_rth
four76226863four__
fours85521493four_s
fourths13374953fourths
furan84320013_furan
gerah9315303_gerah
gooral7310463gooral
goral65125753go_ral
goulash1164273goulash
gourami1083803gourami
gourd71011903gour_d
gourde8107933gourde
gourds8108253gourds
gursh94512333_gursh
hijrah1934273hijrah
hookah16488243hookah
hoorahs13399603hoorahs
hooray123011373hooray
hora76136553ho_ra_
horahs126313873ho_rahs
horal86328673ho_ral
horas86333093ho_ras
houdahs1434243houdahs
hour75827313hour__
houri85915233hour_i
houris94514563houris
hourly12369623hourly
hours85422383hour_s
howdah1634723howdah
hurrah12369183hurrah
jarrah1636683jarrah
joram145816983jo_ram
joual12311653jou_al
journal1484963journal
journo13135293journo
jura116024893_jura_
jural125120483_jural
jurat124829323_jurat
kora86431553ko_ra_
korai97018513ko_rai
koras95927113ko_ras
korat94934433ko_rat
kouroi1036513kouroi
kouros1039183kouros
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
loofah12375813loofah
loral55927823lo_ral
loran55925093lo_ran
lotah85315853lo_tah
lough95118483lou_gh
louma76213633louma_
loumas84812333loumas
lour45430683lour__
loured74617403loured
lours55125293lour_s
loury85716753lour_y
lurch104814633_lurch
moira71012023moira_
moirai886913moirai
mollah11319453mollah
moolah11409193moolah
mora66641273mo_ra_
morae75831193mo_rae
moral75533433mo_ral
moras76438763mo_ras
moray105423793mo_ray
morph121712513mo_rph
mouch124715803mou_ch
mourn77215013mour_n
mourns84111013mourns
mouth105420293mou_th
mura65633293_mura_
mural75225103_mural
muras75329563_muras
neural6311993neural
north86018273no_rth
nougat74712653nougat
nounal639813nounal
nourish1039703nourish
obeah1038993_obeah
odah87018933_o_dah
odograph1577333odograph
odour64710473odour__
odours7418233odour_s
okra86413573_okra_
okras94410973_okras
oompah1334253oompah
opah96218403_o_pah
ora37250833_o_ra_
orach105219233_o_rach
orad56031693_o_rad
oral47638123_o_ral
orra46120723_orra_
ouch95724633_ou_ch
ouph95618373_ou_ph
our36042893_our__
ourang73311063_ourang
ourari63413543_ourari
ourie54027293_ourie
ours47237563_our_s
outran63218883_outran
plural839823plural
porch125918623po_rch
pouch124617083pou_ch
pour611527473pour__
poured95116743poured
pourer84516043pourer
pours74623183pour_s
prutah1136583prutah
pujah17478543_pujah
purdah12288753_purdah
qursh174110843_qursh
rah68052403___rah
rough97819433rou_gh
routh86423073rou_th
rural55821173_rural
sirrah9379753sirrah
sora45746913so_ra_
soras55041013so_ras
souari6311373souari
soucar839323soucar
soudan73210353soudan
sough95320463sou_gh
sour45935893sour__
source8410673source
soured74921863soured
sourer63620213sourer
sourish10310693sourish
sourly93612203sourly
sours55230503sour_s
south85223573sou_th
sovran937153sovran
subah106015213_subah
sura45740293_sura_
surahs94515543_surahs
sural55931263_sural
suras55336323_suras
tora47545993to_ra_
torahs95115643to_rahs
toras55540373to_ras
torch107420933to_rch
toucan838193toucan
touch106519393tou_ch
tough97321983tou_gh
tour45530373tour__
touraco945353touraco
toured74216153toured
tourer64115073tourer
tours55325863tour_s
vouch134611903vou_ch
vouvray1641933vouvray
worth117120523wo_rth
your78623433your__
yourn87512773your_n
yours85217873your_s
youth115315043you_th

Search took 5 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163554.70323966.8
3Display Results3553550.0933817.2
 (SQL Overall)1786913554.93636201.6
 
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.