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 “drier” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

180 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
drier6442396(None) 
brier74527401brier
crier74724461crier
direr64927071direr
dried75321381dried
driers74516731driers
dries64733671dries
driver104714491driver
dryer95111461dryer
frier85225841frier
prier75027761prier
trier54328531trier
wrier84521751wrier
aerier64823162aerier
airer54927892airer
airier64619362airier
arider74717742arider
ariel55228972ariel
armer76924442armer
artier63419732artier
bier65531832_bier
briar75718152briar
briber104714052briber
brie65837902brie_
brief105422602brief
briers85319732briers
briery114510772briery
bries74942152bries
briner84519042briner
burier84324652burier
cried84624292cried
criers83918582criers
cries75438402cries
daiker115113032daiker
darer65230792darer
darker114718692darker
darner74017302darner
darter75320362darter
dater65332312dater
decrier102713562decrier
deer56739022d_eer
defer94619752defer
defier105118652defier
deicer94114412deicer
denier74420692denier
derider93214972derider
deriver114213912deriver
dernier83011942dernier
deter65028042deter
dewier104013462dewier
dicer85426422dicer
dicier94416232dicier
die46759652d_ie_
died66137852d_ied
diel59034602d_iel
dies55653522d_ies
diet57357532d_iet
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire_
dirtier83312092dirtier
diver94827802diver
doer57734702d_oer
doper86128392doper
dopier93515922dopier
dories75232362dories
dorkier122810022dorkier
dormer94415902dormer
dorper94314572dorper
dorser74819182dorser
doser66228562doser
doter65428622doter
dotier73917032dotier
dower95027702dower
dozer158419272dozer
dozier163611632dozier
drainer83012842drainer
draper94315692draper
drawer104711362drawer
drear65016902drear
dree56638322dr_ee
dreed75222842dreed
drees65628522drees
dreg66821652dr_eg
drek96321092dr_ek
drew86221672dr_ew
drib76823262dri_b
dribs85115062dribs
driegh11254562driegh
driest74722752driest
drift95722842drift
drifter11348702drifter
drill64718262drill
driller84311882driller
drily95816522drily
drink106816382drink
drinker12349482drinker
drip76223952dri_p
dripper12349232dripper
drips85417232drips
dript86923872dript
drive95318002drive
drivel105110382drivel
driven105210142driven
drivers114412792drivers
drives105117112drives
droner74717672droner
drover104614592drover
dryers10449272dryers
duiker114110592duiker
duper85519002duper
dyer85522112d_yer
edgier8469732edgier
eerier64320022eerier
firer811229252firer
flier86023402flier
freer86021242freer
friar85414272friar
fried95322912fried
friers94718932friers
fries85535602fries
frizer184011282frizer
fryer115913432fryer
gorier73719372gorier
grief95319782grief
griper94114612griper
hirer85423122hirer
icier74313752icier
kier86526812_kier
lier45942462_lier
mirier83918362mirier
orbier839992orbier
order65019362order
oriel54920422oriel
ormer75218372ormer
osier53518012osier
pier66035292_pier
plier75221282plier
pricer103918292pricer
pried84426862pried
priers84521192priers
pries74339532pries
primer105118682primer
prior74316172prior
prizer174714882prizer
pryer104415312pryer
ricer74726612_ricer
rider65231302_rider
riel46432382_riel
rifer84721982_rifer
rimer75429242_rimer
riper74328402_riper
riser55431052_riser
river85731692_river
ruer46127562_ruer
shier85428942shier
skier95119592skier
slier54827242slier
spier75728032spier
sprier84119062sprier
tier44936142_tier
tried65026912tried
triers64321522triers
tries55742812tries
trimer85717152trimer
triter65120592triter
truer54916642truer
twier84713292twier
urger64116472urger
varier94619352varier
verier94620962verier
vier75428152_vier
warier93722892warier
wirer85124952wirer
wirier94215552wirier
wried95518562wried
wries85827742wries
writer94416512writer
wryer11489302wryer

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001802.42022231.4
3Display Results1801800.0463913.0
 (SQL Overall)1786911802.77964300.5
 
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.