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

392 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
desiring1031214(None) 
deairing10311891deairing
bemiring13239602bemiring
debiting122511202debiting
deciding132210832deciding
defiling132812462defiling
defining133711802defining
deicing11312192de_icing
deliming12310372deliming
demising122012522demising
deriding112512932deriding
deriving132510742deriving
descrying1635102descrying
deserting11713142deserting
deserving1497902deserving
desexing1736292desexing
designing1236622designing
desisting112810382desisting
desorbing1346362desorbing
despairing1445062despairing
despising13167502despising
despiting13179322despiting
destining11311432destining
deviling1311812852deviling
devising133111522devising
heiring113312902he_iring
refiring123513922refiring
rehiring122911882rehiring
residing103015472residing
resiling93520172resiling
resining92919552resining
resiting93521122resiting
resizing182714162resizing
respiring12159902respiring
respring111614062respring
restring91518782restring
retiring92717412retiring
rewiring122911222rewiring
siring75128312__siring
admiring1236133admiring
airing74927503__airing
aspiring1138873aspiring
assuring937773assuring
attiring939483attiring
bearing103624773be_aring
bedspring1544313bedspring
begirding1434333begirding
bemixing20226523bemixing
beriming13310463beriming
besieging1344763besieging
besliming1435493besliming
besmiling1436263besmiling
besting104923923bes_ting
bestirring1343993bestirring
betiding1239913betiding
bewaring14279493bewaring
ceiling103416723ce_iling
censoring1238783censoring
censuring1237603censuring
centring112112953centring
cering94522533ce__ring
cessing103814813ces_sing
chairing143110773chairing
choiring14279793choiring
dairying1336353d_airying
daring84928683d__aring
dashing125917893das_hing
dayspring1642613dayspring
dealing94323233de_aling
deaning94020473de_aning
deashing134210953deashing
deaving123814753de_aving
debarking1735383debarking
debarring1335713debarring
debasing12238063debasing
debating123213733debating
deboning12109153deboning
debriding1446483debriding
debuting12268633debuting
decaying15239453decaying
deceiving1635733deceiving
decerning1337293decerning
decking153915593de_cking
declaring1339573declaring
declining13129353declining
decoding132410053decoding
decoying15208763decoying
decrying15237413decrying
decurving1634723decurving
deducing1336423deducing
deeding103315123de_eding
deeming113913123de_eming
defacing15238683defacing
defaming15238463defaming
deferring1436143deferring
deforcing1636063deforcing
deforming1636703deforming
defusing13227933defusing
defuzing22195253defuzing
defying15328823de_fying
degerming1435753degerming
dehiscing1643733dehiscing
dehorning1455243dehorning
dehorting1447213dehorting
deifying1637633deifying
deigning1137753deigning
dekeing13358353de_keing
deking125614553de__king
delating103119603delating
delaying133210973delaying
deleing93313953de_leing
deleting103314423deleting
deliria868303deliri_a
delirium1146583delirium
delisting112710503delisting
delivering1545173delivering
deluding1137683deluding
deluging1137123deluging
delving123711573de_lving
demarking1736773demarking
demerging1436643demerging
demitting13239073demitting
demoing11311753de_moing
demoting12311423demoting
demurring1335253demurring
denning93515173de_nning
denoting10311753denoting
densifying1844813densifying
denting94422183de_nting
denuding1137113denuding
denying123711293de_nying
departing1349513departing
deperming1537113deperming
depicting1537813depicting
deploring1337853deploring
deponing121211213deponing
deporting1369593deporting
deposing12129773deposing
depositing1446933depositing
depriving1636403depriving
deputing12238793deputing
derailing112011313derailing
derating103222283derating
desalting1138843desalting
desanding12207653desanding
describe1346243describe
describing1645073describing
descried1248073descried
descrier1157623descrier
descries11311923descries
deservings1593663deservings
design8408933desi_gn_
designings1342623designings
designs9328313desi_gns
desilvering1663303desilvering
desinent9312963desinent
desire7415303desir__e
desired9311983desir_ed
desirer8310783desir_er
desirers939263desirers
desires81316133desir_es
desirous947783desirous
despoiling1445113despoiling
destain8412083destain_
destaining1267943destaining
destains9311813destains
destine83719953des_tine
destiny113111463des_tiny
destrier9311823destrier
destroying1564903destroying
desugaring1343263desugaring
detailing112510413detailing
detaining112510473detaining
deterging1237853deterging
deterring1138623deterring
deticking1736043deticking
detouring1136973detouring
detoxing1736313detoxing
deucing1139393de_ucing
deveining1436393deveining
develing133212733develing
deviating14311083deviating
devilling1436703devilling
devoicing16145223devoicing
devoting1338823devoting
devouring1435953devouring
dewaxing20215293dewaxing
dewing114115703de__wing
deworming1635043deworming
dextrin1587543dextrin_
dextrine1688253dextrine
dextrins16117823dextrins
dezincing2244183dezincing
dicing105718763d__icing
dieing84018653d__ieing
dieseling1146143dieseling
diking124320243d__iking
dining84525133d__ining
dirking133812603d__irking
dirling93316073d__irling
disarming1338803disarming
discing113914593dis_cing
discoing12511453discoing
dishing124017103dis_hing
disking134615493dis_king
disliking1537313disliking
dissing94517683dis_sing
disusing1039003disusing
dividing1437183dividing
diving113717953d__iving
divining1338413divining
dosing83920273dos__ing
dossing93313273dos_sing
dowering132510613dowering
draining103312673draining
dressing102810423dres_sing
driving123910713d_riving
during84419403d__uring
dusking133912053dus_king
dusting93618993dus_ting
dwining12269293d_wining
earing75235483_e_aring
earring83519013_earring
editing9313133_editing
eliding93414343_eliding
ensiling9410723ensiling
ensuring9310173ensuring
enuring8813883_enuring
erring73816483_e_rring
eserine7415903_eserine
espying1336193_espying
esquiring19174023_esquiring
estrin6315923_estrin_
estrins7315853_estrins
eviting11511373_eviting
exiling15311083_exiling
exiting15311393_exiting
expiring1836253expiring
fairing113614013_fairing
fearing113520033fe_aring
fessing113812863fes_sing
festering132413173festering
fevering152510083fevering
firing104021723__firing
gearing92818843ge_aring
gesturing1136653gesturing
glairing1047283glairing
hearing113324163he_aring
heiling113616363he_iling
heisting123411043heisting
herring113615883he_rring
hiring104421603__hiring
inspiring1246183inspiring
insuring9311153insuring
iring66025423___iring
jeering153513043je_ering
jessing153710623jes_sing
jesting154317713jes_ting
lairing83715343_lairing
leering83417643le_ering
leniting9312353leniting
lesioning1046443lesioning
levering122212503levering
lustring9269723lustring
measuring1236123measuring
meriting11314693meriting
meshing134513813mes_hing
messing103916393mes_sing
metering112915633metering
metring103215293me_tring
miring93723803__miring
misfiring1536973misfiring
nearing83020333ne_aring
nesting84320443nes_ting
nestling958893nestling
oestrin7312243oestrin_
oestrins8312673oestrins
pairing103716733_pairing
peering103520353pe_ering
peining104619153pe_ining
peising103416763pe_ising
periling11316863periling
perspiring1544853perspiring
pestering122315663pestering
pestling111010253pestling
petering112516813petering
positing11312303positing
prefiring1559073prefiring
prehiring1548383prehiring
presiding13510903presiding
prewiring1547893prewiring
quiring17159993_quiring
rearing83128783re_aring
reboring11312783reboring
reciting113118073reciting
refiling123116533refiling
refining122416863refining
refixing19329793refixing
regiving13269713regiving
reining84425323re_ining
reiving113316843re_iving
relining93218743relining
reliving122713343reliving
remising112516453remising
remixing182810333remixing
reoiling93217213reoiling
repairing12310013repairing
repining114116593repining
requiring1937043requiring
rerising93017783rerising
resailing103314253resailing
resawing122311433resawing
resaying122512453resaying
rescoring12310603rescoring
rescuing1139623rescuing
reseeing92412623reseeing
reseizing19311233reseizing
reserving131110643reserving
resewing122712263resewing
reshining13310743reshining
resifting133512093resifting
resigning1139463resigning
resilin72913973resilin_
resilins83013373resilins
resisting103215313resisting
resitting103414873resitting
resoling92916303resoling
resorbing1269353resorbing
resorting10614613resorting
resowing123111523resowing
respiting121912863respiting
resprang11175843resprang
resprings12156253resprings
resprung11164103resprung
resting85031183res_ting
restoring10314613restoring
restrings10159293restrings
restrung9176443restrung
resuming11310083resuming
resurging1138613resurging
retieing92913713retieing
retiling93319483retiling
retiming113014193retiming
revering122918073revering
reviling122917213reviling
revising122714403revising
reviving152910503reviving
rosining92411423rosining
searing83330923se_aring
securing11310413securing
seining84020773se_ining
seising84018863se_ising
seizing174114833se_izing
sering74731813__sering
severing122013853severing
sewering122411093sewering
siding83822133__siding
siping94220633__siping
siting74126623__siting
sizing163616443__sizing
soring74731883__soring
speiring113711263speiring
spiring103918183_spiring
spring94526013__spring
squiring18177563squiring
string75327563__string
suspiring1245703suspiring
tearing84021493te_aring
tenuring938863tenuring
testing86021053tes_ting
tiring74023093__tiring
umpiring1336093umpiring
unstring9312093unstring
untiring9312003untiring
upsizing2035413upsizing
upspring1335703upspring
veering113213683ve_ering
veiling113615293ve_iling
veining114713893ve_ining
veluring1237563veluring
vesting114618683ves_ting
vesturing1337203vesturing
visiting1238393visiting
visoring1238373visoring
wairing113414313_wairing
wearing113318863we_aring
weirding1335593we_irding
westering132112643westering
westing115020273wes_ting
wiring104521023__wiring
yessing113210063yes_sing
zesting174515333zes_ting

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623927.15620425.1
3Display Results3923920.1862107.5
 (SQL Overall)1786913927.74823062.9
 
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.