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

489 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
durrie7371326(None) 
currie84317261currie
dhurrie1153951dhurrie
durries83817351durries
burdie93615022burdie
burnie83715412burnie
burrier93613552burrier
corrie83621232corrie
curie74533042cu_rie
curried103313652curried
currier93316702currier
curries93723162curries
darkie113714012darkie
dearie73319812dearie
derries83124622derries
derris73615272derris
dhurries1255582dhurries
dormie9312622dormie
duckie133511662duckie
duddie9348862duddie
dure56341812du_r_e
durr55624352durr__
durra65315792durr_a
durras74713372durras
durrs65519992durr_s
furrier103513662furrier
gurries83515952gurries
hurried113511042hurried
hurrier103412942hurrier
hurries103919652hurries
murre74821072murr_e
murries94118672murries
murrine9411482murrine
ourie54027302ou_rie
aerie54634603_aerie
arris56824683_arris
arrive91311793_arrive
auntie64317703auntie
aurae54128113au_rae
aurate64426473aurate
aurei54821863aurei_
auric74521743au_ric
auris55331533au_ris
aurorae739663aurorae
barbie105018353barbie
barmie103816393barmie
barre75929543barr_e
barrier94017733barrier
barrio8312573barrio
berried103714053berried
berries94423553berries
birdie94013783birdie
birkie124110133birkie
blurrier1035163blurrier
bourree91311343bourree
bourride1144403bourride
brie65837903__brie
budgie104310343budgie
buppie12288733buppie
burble104617703burble
burdies104117563burdies
burgee97120593burgee
burgle94815863burgle
buried94822373bu_ried
burier84324653bu_rier
buries84633273bu_ries
burin75626063bu_rin
burke115122763bu_rke
burkite1337003burkite
burlier93514413burlier
burnies94017823burnies
burr65631233burr__
burred95820723burred
burrer83718473burrer
burriest102911213burriest
burring104016993burring
burrito936223burrito
burro75018493burr_o
burros85114993burros
burrow114610803burrow
burrs74925653burr_s
burry105221563burr_y
bursae84515603bursae
burse75527253bu_rse
byrnie11348573byrnie
carnie84421093carnie
carried103717153carried
carrier93619583carrier
carries94328013carries
cirri7710723cirri_
corbie103618203corbie
corries94026803corries
cowrie113814283cowrie
cuddie104011173cuddie
cupric1249123cupric
cuprite1159683cuprite
curare84916953curare
curari84414403curari_
curarine10610713curarine
curaris94114773curaris
curarize1988853curarize
curate85226243curate
curdier103312623curdier
curdle95514313curdle
cure66149123cu_r_e
curia74523773cu_ria
curiae84518373curiae
curies84934023cu_ries
curio74221213cu_rio
curite85222943curite
curlier93314183curlier
curr65429653curr__
curran8312023curran
curred94319263curred
curricle12145933curricle
curriers103410753curriers
curriery13326163curriery
curring103616843curring
currish1238353currish
currs75624393curr_s
curry105920343curr_y
curse75829143cu_rse
cursive1237833cursive
curule83614123curule
curve104920023cu_rve
curvier123110663curvier
cutie76925933cu_tie
dairies84217733dairies
darbies104216983darbies
dare55848863d_ar_e
daric85623123d_aric
darkies124015753darkies
darkle113813943darkle
dartle73714833dartle
dassie74615573dassie
daubries1136743daubries
dautie72914703dautie
dawtie103011093dawtie
dearies83526273dearies
debride1138593debride
debrief1337623debrief
debris93311493debris
decree93117783decree
decried112612863decried
decrier102713563decrier
decries103319813decries
degree82814853degree
deprive1338303deprive
derail74218813derail
derate74531233derate
derbies103016053derbies
dere56845903d_er_e
deride84420033deride
derive103817043derive
dermic114511913dermic
dermis94717163dermis
dernier83011943dernier
derrick1435803derrick
derriere936043derriere
derrises93012783derrises
derry94721373derr_y
desire7415303desire
dexie134716893d_exie
diaries83321953diaries
dickie133913113dickie
didie74120563d_idie
die46759653d___ie
diorite8314913diorite
dire56644143d_ir_e
dirge75117073d_irge
dirtied93210853dirtied
dirtier83312093dirtier
dirties83119383dirties
dobie84920333d_obie
doggie93910893doggie
dogie75222793d_ogie
donsie7613643donsie
doobie94712683doobie
doolie73916833doolie
doozie163910653doozie
dore56353303d_or_e
dories75232363d_ories
dorkier122810023dorkier
dormice1237133dormice
dormin9312313dormin
dorr56627723dorr__
dorrs65520593dorr_s
dourine8311453dourine
dowie94721143d_owie
dowries114413983dowries
doxie136017153d_oxie
drail65020973d_rail
drain65222893d_rain
drake104918303d_rake
drape85319633d_rape
drave95219273d_rave
dree56638323d__ree
drib76823263d__rib
dried75321383d__ried
drier64423963d__rier
dries64733673d__ries
drip76223953d__rip
drive95318003d_rive
droid74218543d_roid
droit65127123d_roit
drone65324983d_rone
drove95518063d_rove
drudge9317903drudge
druggie10134083druggie
druid74111323d_ruid
drupe85012993d_rupe
druse64817663d_ruse
dualize1759763dualize
dubbin11329263dubbin
duce76933503du__ce
duchies133312313duchies
duci76422623du_ci_
duckier143911793duckier
duckies143613813duckies
ductile1048483ductile
dude65629663du__de
due45249863du___e
duende836923duende
duffle13368533duffle
dui46433383du__i_
duit56241583du__it
duke95628103du__ke
dulia61014983du_lia
dulse65415043du_lse
dummied13346723dummied
dummies123012133dummies
dumpier12409653dumpier
dunce86319263du_nce
dune56137583du__ne
dungier9368583dungier
dunite7315013dunite
dunlin739723dunlin
dunnite857333dunnite
duomi8310133duomi_
dupe76630603du__pe
duperies11312813duperies
duple85315863du_ple
dura55232113du_r_a
durable102312723durable
dural64923893du_ral
duramen1096903duramen
durance1059113durance
duras65727733du_ras
durative1239073durative
durbar968723durbar
dured75025403du_red
dures65635923du_res
duress74712063duress
durian7312003durian
during84419403during
durion7510963durion
durn56127633du_r_n
durned84113173durned
durning93511733durning
durns64819873du_rns
duro56228023du_r_o
duroc84513143du_roc
durocs9569703durocs
duros65422693du_ros
durst66125173du_rst
durum8513203du_rum
durums948153durums
duskier12409433duskier
dustier83814133dustier
duties74921903du_ties
eerie55228533_eerie
eucrite939903eucrite
eyrie88117833_eyrie
faerie93514683faerie
farcie114816473farcie
farrier103514893farrier
feirie939553feirie
ferlie92814053ferlie
ferric1139993ferric
ferried113411533ferried
ferries103521083ferries
ferrite103312753ferrite
firrier103410133firrier
flurried12235283flurried
flurries11188913flurries
forrit91916623forrit
furane94015493furane
furies95126373fu_ries
furore9410013furore
furred104514433furred
furriers11369493furriers
furriery14395683furriery
furriest112910793furriest
furrily1337613furrily
furriner11267303furriner
furring114013143furring
furrow12427743furrow
furry116719283furr_y
furtive1337173furtive
furze176815813fu_rze
furzier19318103furzier
girlie73711463girlie
gurge75419783gu_rge
gurgle83912473gurgle
gurry94515413gurr_y
gussie72910153gussie
harried113815533harried
harrier104417753harrier
harries103525493harries
herried113514463herried
herries104025073herries
horrid10311563horrid
hubris11218973hubris
hunkie133812383hunkie
hurdies114015663hurdies
hurdle103712793hurdle
hurlies103315333hurlies
hurrah12369183hurrah
hurray12459913hurray
hurriers11358893hurriers
hurry114917183hurr_y
hurtle93512943hurtle
jerrid14259143jerrid
jerries143817513jerries
junkie17339603junkie
juried144212443ju_ried
juries134120633ju_ries
kerria10339913kerria
kerries113317913kerries
kukri835043kukri_
kukris934453kukris
kyrie123712903_kyrie
lorries74518353lorries
lubric1097983lubric
luckie123611413luckie
lucre76415523lucr_e
luggie8318903luggie
lure45142463lu_r_e
lurid64618973lu_rid
married104715303married
marrier93817523marrier
marries93825283marries
merrier92612303merrier
morris83814733morris
mure65941333mu_r_e
murein8311763murein
murid84520583mu_rid
murine84220023murine
murkier133110273murkier
murr65225133murr__
murra74519083murr_a
murrain937763murrain
murras84916013murras
murres85019043murres
murrey114312263murrey
murrha11366453murrha
murrhine1344313murrhine
murrs75521303murr_s
murry105120233murr_y
muskie123412543muskie
nudie65118673nu_die
nurse54420123nu_rse
nutria639913nutria
oorie53026363_oorie
orrice81410163_orrice
orris54516553_orris
ourari63413543ourari_
ouraris73512933ouraris
outlie62419533outlie
outre53922203outr_e
outride82615683outride
outrig72812853outrig
outvie92412803outvie
pardie96021443pardie
parried103615723parried
parrier93717653parrier
parries93925843parries
peerie83617893peerie
perdie94718513perdie
perries93226603perries
puerile9310093puerile
pugree92112473pugree
punkie123513613punkie
pure65543333pu_r_e
puree74632843pu_ree
purfle112511183purfle
purge85324603pu_rge
puri65931443pu_ri_
purin75527593pu_rin
purine85321893purine
puris75332023pu_ris
purlieu938143purlieu
purlin83615863purlin
purline93516533purline
purple102712683purple
purr64925813purr__
purred94218073purred
purring104515823purring
purrs75320433purr_s
purse76028893pu_rse
pursier94012753pursier
pursue84512253pursue
purtier93214093purtier
purview1534233purview
putrid9311173putrid
puttie84116303puttie
quare143920543quar_e
quarried1836093quarried
quarrier1736843quarrier
quarries1749943quarries
quarte154115323quarte
queried1738683queried
querier16310013querier
queries16315873queries
quire144917133quir_e
rubric1097823rubric
scurried11267053scurried
scurries102911483scurries
scurril945113scurril
scurrile1055073scurrile
serried82513973serried
serries73925353serries
sirree64017343sirree
slurried9285943slurried
slurries82710413slurries
sorrier72313733sorrier
sortie63621993sortie
spurrier10297693spurrier
spurries102311323spurries
sucre75019103sucr_e
sunrise7310813sunrise
sure45447413su_r_e
surfier102613543surfier
surge65027693su_rge
surlier72915443surlier
surmise9311083surmise
surprise1037673surprise
surprize1945843surprize
surra55521343surr_a
surras65919533surras
surrey94414583surrey
survive1335933survive
tarre55825633tarr_e
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
terrae62915213terrae
terrier73414963terrier
terries73425633terries
terrine72517573terrine
territ63421373territ
torrid7311853torrid
tugrik1134283tugrik
turbid979713turbid
turbine9310303turbine
turbit8715113turbit
turdine8310283turdine
turfier10249793turfier
turgid868023turgid
turgite837973turgite
turnip836593turnip
turret63121853turret
turtle63213573turtle
tushie939723tushie
unrig61711413_unrig
unrip72012863_unrip
unripe82012093_unripe
untie54425493_untie
uprise82313693_uprise
uraei53016083_uraei
urare56322553_urare
urari54619963_urari_
uraris63817273_uraris
urase54624693_urase
urate55432163_urate
urbia7311143_urbia
ureic74514463_ureic
ureide7310363_ureide
urge54722423_u_rge
uric63624943_u_ric
urine55026603_urine
ursae55214453_ursae
ursid6311483_ursid
ursine64114123_ursine
worried11308693worried
worrier102311683worrier
worries104117133worries
worrit92313313worrit
yuppie13297133yuppie

Search took 7 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.373479064.3
2DLD Change Limit1127164895.83019333.8
3Display Results4894890.1702876.5
 (SQL Overall)1786914896.37328038.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.