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

257 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
direr6492707(None) 
airer54927891airer
darer65230791darer
dicer85426421dicer
diker105524551diker
dimer85625601dimer
diner65632901diner
dire56644141dire_
diver94827801diver
drier64423961drier
firer811229251firer
hirer85423121hirer
wirer85124951wirer
admirer1035522admirer
adorer74713452adorer
aider65431132aider
aimer75926822aimer
aired66032922aired
airers64922312airers
airier64619362airier
aiver85725162aiver
barer74535802barer
bider85728372bider
bier65531832bi_er
biker116022562biker
biner75930692biner
birder94915492birder
birler85715082birler
birr66022362bir_r
biter75030032biter
borer75131272borer
brier74527402brier
carer74942332carer
cider84723312cider
cire65836372cire_
cires74932912cires
citer74827332citer
corer75538872corer
crier74724462crier
curer75030752curer
daiker115113032daiker
dare55848862dare_
dared75935012dared
darers75921872darers
dares66146702dares
darker114718692darker
darner74017302darner
darter75320362darter
dater65332312dater
dearer74822802dearer
deer56739022d_eer
defer94619752defer
deicer94114412deicer
dere56845902dere_
desirer8310782desirer
deter65028042deter
dialer74315432dialer
diaper94513112diaper
dibber114614712dibber
dice75841892dice_
diced95824682diced
dicers94720742dicers
dices86434242dices
dicey114819332dicey
dicier94416232dicier
dicker134521402dicker
die46759652di_e_
died66137852di_ed
diel59034602di_el
dies55653522di_es
diet57357532di_et
dieter73516772dieter
differ133910842differ
digger94616082digger
dike95935762dike_
diked115024682diked
dikers114418792dikers
dikes105831332dikes
dikey135116422dikey
dime76237642dime_
dimers94321092dimers
dimes85833042dimes
dimmer114112612dimmer
dinar66319892dinar
dine55555332dine_
dined76431992dined
dinero75612642dinero
diners75525952diners
dines66449152dines
dinger85323672dinger
dinner74217162dinner
dipper114017792dipper
diram84419472diram
direct93817332direct
direly10311562direly
direst75024242direst
dirge75117072dirge
dirges84915102dirges
dirk96326832dir_k
dirked124912272dirked
dirks105619522dirks
dirl57430022dir_l
dirled84514902dirled
dirls64720502dirls
dirt55550382dir_t
dirtier83312092dirtier
dirts66824462dirts
dirty95617802dirty
diseur738842diseur
dite55547552dite_
dites66339152dites
dither104417682dither
dive85634772dive_
dived106321372dived
divers105024962divers
divert103922812divert
dives95832402dives
dizen155214932dizen
doer57734702d_oer
doper86128392doper
dore56353302dore_
dormer94415902dormer
dorper94314572dorper
dorr56627722dor_r
dorser74819182dorser
doser66228562doser
doter65428622doter
dourer74215272dourer
dower95027702dower
dozer158419272dozer
drear65016902d_rear
dree56638322d_ree
dreg66821652d_reg
drek96321092d_rek
drew86221672d_rew
dried75321382dried
driers74516732driers
dries64733672dries
driver104714492driver
dryer95111462dryer
duiker114110592duiker
duper85519002duper
dure56341812dure_
dured75025402dured
dures65635922dures
durr55624352dur_r
dyer85522112d_yer
eider64624742eider
fairer95212062fairer
farer86733142farer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
fire76245592fire_
fired94829742fired
firers94922682firers
fires85740752fires
firmer114712442firmer
fiver116024942fiver
fixer154717832fixer
frier85225842frier
giber85417702giber
girder84312062girder
giver94921202giver
hider95024082hider
hiker125119392hiker
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirers94518062hirers
hires86134342hires
idler65015662idler
ire36943172_ire_
ired55131872_ired
ires45639282_ires
jiber145115702jiber
jiver155119052jiver
kier86526802ki_er
kiter95523212kiter
liber74723622liber
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
lire47845292lire_
liter54736342liter
liver85132962liver
lurer54625312lurer
merer75126232merer
miler75733062miler
mimer94825762mimer
miner76933542miner
mire66748232mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918362mirier
mirker123712692mirker
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
niter55028972niter
oiler54628282oiler
parer75839902parer
pier66035292pi_er
piker115622842piker
piper96523192piper
prier75027762prier
purer75127902purer
rarer54731702rarer
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
serer55935512serer
siker95326032siker
sire46150412sire_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
siver85728612siver
sizer145521812sizer
sorer56236592sorer
surer54833102surer
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tire46143352tire_
tired65228902tired
tires55437492tires
titer55430612titer
trier54328532trier
vier75428152vi_er
viler86324162viler
viper105017302viper
vireo84816452vireo
vires84529682vires
wider94826352wider
wiper105421292wiper
wire75839812wire_
wired95327642wired
wirers94617892wirers
wires86034912wires
wirier94215552wirier
wiser85522802wiser
wiver115924512wiver
wrier84521752wrier
yarer84321572yarer
yirr76513572yir_r

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 Filter178691538000.656272394.8
2DLD Change Limit538002575.23310280.9
3Display Results2572570.1701511.8
 (SQL Overall)1786912576.05929491.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.