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

428 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
desirer831078(None) 
desire7415301desire_
desired9311981desired
desirers939261desirers
desires81316131desires
deaired9411532deaired
dearer74822802de_arer
decider114213182decider
decrier102713552decrier
defier105118652defi_er
defiler113911882defiler
definer114413772definer
deicer94114412de_icer
deliver113312242deliver
demirep1236212demirep
demurer1037872demurer
denier74420692deni_er
derider93214972derider
deriver114213912deriver
descrier1157622descrier
deserter91211602deserter
deserver12118382deserver
designer1036542designer
desilver12286502desilver
despairer1243692despairer
despiser1136342despiser
destrier9311822destrier
deviser114212392deviser
dewier104013462dewi_er
direr64927072d__irer
resider84615802resider
retirer74715012retirer
admirer1035523admirer
aerier64823153aeri_er
airer54927893__airer
aspirer967903aspirer
assurer767793assurer
bearer85323913be_arer
beerier93613023beerier
belier84423563beli_er
bemire103312803bemire_
bemired123410633bemired
bemires113212833bemires
beshiver1634483beshiver
beshrew1554393beshrew
beside95114613beside_
besides104814533besides
besieger1144683besieger
bestrew1248003bestrew
busier85219723busi_er
ceiler84013963ce_iler
censurer10228133censurer
cosier84423753cosi_er
daiker115113033d_aiker
darer65230793d__arer
dasher104318983das_her
dashier114311183dashier
deader84220473de_ader
deafer104114813de_afer
deair65817193deai__r
deairs74013783deair_s
dealer74122143de_aler
dearie73319813dearie_
dearies83526273dearies
debarker15155503debarker
debaser103510413debaser
debater104114693debater
debited113311623debited
deboner103110483deboner
debrief1337623debrief
decare93919153decare_
decares102818533decares
decayer13339353decayer
deceiver1436233deceiver
deciare10710663deciare_
deciares11510633deciares
decibel1235993decibel
decide104116873decide_
decided124312423decided
deciders123510753deciders
decides114217653decides
decile94619213decile_
deciles104417723deciles
decipher1644423decipher
decker135215993de_cker
declarer1148063declarer
decliner113710843decliner
decoder113712293decoder
decoyer13348683decoyer
decree93117783de_cree
decreer10269123decreer
decried112612853decried
decriers11299733decriers
decries103319803decries
deedier93011593deedier
deeper93613503de_eper
deer56739023de___er
defacer132810363defacer
defamer132710323defamer
defer94619753de__fer
deferrer12135593deferrer
deffer134411303de_ffer
defied115016383defi_ed
defiers113913993defiers
defies104624053defi_es
defile105216663defile_
defiled124013103defiled
defilers12439473defilers
defiles114016843defiles
define104718143define_
defined123813823defined
definers124211193definers
defines114118683defines
deforcer14246903deforcer
deformer14247943deformer
defter104215923de_fter
defuser115110503defuser
degree82814853de_gree
dehorner1235523dehorner
deice84320033de_ice_
deiced104214483de_iced
deicers103612733de_icers
deices94119373de_ices
deifier113013123deifier
dekare112811563dekare_
dekares122710873dekares
delayer113010533delayer
delime9314043delime_
delimed11310723delimed
delimes10314193delimes
deliria868303deliria
deliverer1344503deliverer
delivers123310753delivers
delivery15286553delivery
deluder9168333deluder
delver104913493de_lver
demerger12127373demerger
demies94825803demi_es
demireps1343993demireps
demise94618323demise_
demised113613683demised
demises103719563demises
demister11310223demister
demure9311533demure_
demurrer1144043demurrer
denied84318633deni_ed
deniers84515183deniers
denies74729643deni_es
denimed1159233denimed
denizen1737663denizen
denser74115193de_nser
denuder9167603denuder
depicter1356853depicter
deplorer1136343deplorer
deporter1169393deporter
deposer104011843deposer
depriver1446293depriver
depside1138403depside_
depsides1238503depsides
dere56845903de__re_
deride84420033deride_
derided102914253derided
deriders102411853deriders
derides93420853derides
deringer1038143deringer
derive103817043derive_
derived123912763derived
derivers123811363derivers
derives114017813derives
dernier83011943dernier
derriere936043derriere
derries83124623derries
desalter938363desalter
describer1444613describer
descried1248073descried
descriers1245693descriers
descries11311923descries
descry1256183descr_y
desert72725493deser_t
deserted101012203deserted
deserters10129983deserters
deserts82513053deserts
deserve11108703deserve
deserved13108133deserved
deservers13107293deservers
deserves12109893deserves
desex13311983des__ex
desexed1636183desexed
desexes1537833desexes
design8408933desi_gn
designed1136943designed
designee1087753designee
designers1136003designers
designs9328313designs
desilvers13306083desilvers
desinent9312963desinent
desiring10312143desiring
desirous947783desirous
desist74818813desi_st
desisted1039783desisted
desists83611723desists
deskmen1435023deskmen
desorb95210203desor_b
desorbed1236443desorbed
desorbs10437713desorbs
despair1045463despair
despaired1344503despaired
despairers1343103despairers
despise1038683despise_
despised1236923despised
despisers1245153despisers
despises1139433despises
despite10410123despite_
despited1248323despited
despites11410313despites
despoiler1243963despoiler
dessert82916453dessert
destine83719953destine_
destined103312453destined
destines93619663destines
destriers1038143destriers
destroy1138153destroy
destroyer1344553destroyer
desugar944033desugar
detailer9268673detailer
detainer92910793detainer
deter65028043de__ter
deterger10147593deterger
deterrer9137013deterrer
deticker1545283deticker
device124512163device_
devices133212583devices
deviled124112183deviled
devise104215753devise_
devised123712563devised
devisee113812713devisee
devisers12339863devisers
devises114116763devises
devisor11357043devisor
devourer1235063devourer
dewater112912423dewater
dewormer14256323dewormer
dexie134716893dexi_e_
dexies145018343dexi_es
dexter143810893de_xter
dicer85426423d__icer
dicier94416233dici_er
diesinker1462513diesinker
diester83013683dies_ter
diker105524553d__iker
dimer85625603d__imer
diner65632903d__iner
dire56644143d__ire_
disarmer1138033disarmer
dishier113613403dishier
disinter9310673disinter
disliker13358643disliker
disorder1038133disorder
ditsier83010293ditsi_er
diver94827803d__iver
divider12278953divider
diviner11369883diviner
dopier93515923dopi_er
doser66228563dos__er
dosser74417973dos_ser
dossier83711693dossier
dotier73917033doti_er
dourer74215273d_ourer
dozier163611633dozi_er
drainer83012843drainer
drearier9297923drearier
dresser83611953dres_ser
dressier956863dressier
drier64423963d_ri_er
driver104714493d_river
duiker114110593d_uiker
duskier12409433duskier
duster74919723dus_ter
dustier83814133dustier
easier64218463easi_er
edgier8469733edgi_er
eelier64216463eeli_er
eerier64320023eeri_er
eider64624743_e_ider
ensurer73011903ensurer
epimer10109153_epimer
esker94412983_es_ker
ester54727713_es_ter
eviler94811893_eviler
exiler134712183_exiler
expirer1635993expirer
fairer95212063_fairer
fearer94820183fe_arer
fester94723513fes_ter
firer811229253__firer
gesturer935983gesturer
hearer94323643he_arer
heifer1238203he_ifer
heired103813043he_ired
heister103613623heister
hirer85423123__hirer
hosier94219613hosi_er
insider849733insider
inspirer1045183inspirer
insurer73312803insurer
jeerer13389933je_erer
jester134319153jes_ter
keister113011573keister
kestrel1137113kestrel
learier73415663learier
leerier73111503leerier
leister73212753leister
lesser63514853les_ser
levier94013873levi_er
measurer1035953measurer
meister93114163meister
merer75126233me__rer
merrier92612303merrier
meshier123410853meshier
messier93412923messier
metier83517693meti_er
nearer64618893ne_arer
nester64124183nes_ter
nestler73510453nestler
newsier10147223newsi_er
nosier63716323nosi_er
osier53518013_osi_er
peskier13319113peskier
pester84827593pes_ter
pesterer102412713pesterer
pestier94317403pestier
presider11410423presider
rearer64928913re_arer
reciter94117263reciter
refiner105316913refiner
refire95419473refire_
refired115116993refired
refires104820313refires
rehire95415863rehire_
rehired115013153rehired
rehires105016113rehires
reiver95318293re_iver
relier65826183reli_er
repairer1036783repairer
repiner94816903repiner
requirer17156113requirer
rescuer939033rescuer
reserver11119633reserver
reside74224933reside_
resided95217703resided
residers93311883residers
resides84523283resides
resigner937793resigner
resile64627673resile_
resiled84621983resiled
resiles74026543resiles
resilver11337503resilver
resined84522653resined
resister8311653resister
resite64128453resite_
resited85122423resited
resites74027793resites
resize154117723resize_
resized174614903resized
resizes164216843resizes
resorter8312183resorter
respire9411543respire_
respired1148993respired
respires10311903respires
rester63832433res_ter
restorer84813723restorer
resumer9410113resumer
retire64927013retire_
retired84620143retired
retiree75019083retiree
retirers84311533retirers
retires74726213retires
reverer103815833reverer
reviler104314973reviler
reviser104114663reviser
reviver134411373reviver
rewire95421413rewire_
rewired115413283rewired
rewires104717113rewires
rosier64221263rosi_er
searer65432023se_arer
securer958253securer
seiner64622483se_iner
seiser65318343se_iser
seizer154114573se_izer
serer55935513__serer
severer103511563severer
sexier13310683sexi_er
siker95326033__siker
sire46150413__sire_
sired66134283__sired
siree55238813__siree
siren54525823__siren
sires55945373__sires
siver85728613__siver
sizer145521813__sizer
sorer56236593__sorer
surer54833103__surer
tearer64822903te_arer
tearier73815613tearier
terrier73414963terrier
tester64227153tes_ter
testier74015643testier
undesired1147523undesired
usurer638103_usurer
veiler93814353ve_iler
veiner94514753ve_iner
veliger1137313veliger
venire93513693venire_
venires103012453venires
verier94620963veri_er
vesper1138083ves_per
vetiver1336103vetiver
visiter1038863visiter
wearer94319403we_arer
wearier103613283wearier
weiner94214133we_iner
weirder1144923we_irder
wester94222893wes_ter
wirer85124953__wirer
yester93417983yes_ter
zester153617793zes_ter
zestier163010223zestier

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.390458182.1
2DLD Change Limit1340274286.86019537.5
3Display Results4284280.1702517.6
 (SQL Overall)1786914287.42024082.3
 
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.