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

212 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
residue868986(None) 
reside74224931resid_e
residua8286621residua
residues9338811residues
beside95114612besid_e
preside10715612presid_e
reissue745872reissue
relique1636822relique
rescue8313002res_cue
resid64124092resid__
resided95217702resided
resider84615802resider
resides84523282resides
resids74219152resid_s
residual9245442residual
residuum1143062residuum
resile64627672resi_le
resite64128452resi_te
resize154117722resi_ze
retinue75414842retinue
aside65122083_asid_e
bedside1156843bedsid_e
besides104814533besides
besiege1035413besiege
betide95115973betid_e
bezique2743173bezique
cesium1039583cesi_um
decide104116873decid_e
decidua1144493decidua
deciduae1243743deciduae
depside1138403depsid_e
deride84420033derid_e
desire7415303desi_re
detinue85010033detinue
eide55832243_e_id_e
elide64922643_elid_e
endue64215353_e_ndue
fescue1137493fes_cue
fireside1247003firesid_e
foreside12310303foresid_e
inside7613453insid_e
onside7511803onsid_e
oreide7311673ore_id_e
perdue93912633pe_rdue
perique1837523perique
pesade9311103pesad_e
presided12410553presided
presider11410423presider
presides11414913presides
presidia1147273presidia
presidio1146153presidio
presidium1445303presidium
reargue836463reargue
rebid85121363rebid__
rebidden1243033rebidden
rebids94015533rebid_s
recede95515533reced_e
recipe103414893reci_pe
recite83625113reci_te
recode93618713recod_e
reddle83815913re_ddle
rede55037673re__d_e
rediae74221993redi_ae
redid74922393redid__
redub84212413re__dub
reduce9713253re__duce
redux133811103re__dux
redye94413473re__dye
refigure1254693refigure
refile95122373refi_le
refine95225693refi_ne
refire95419473refi_re
regime95313943regi_me
reginae84713453reginae
regius7311923regi_us
regive104814323regi_ve
reglue739703re_glue
rehinge1148503rehinge
rehire95415863rehi_re
reinduce1165423reinduce
reissued944903reissued
reissuer854523reissuer
reissues845993reissues
reive85522943re_i_ve
rejudge1634023rejudge
rekindle1344643rekindle
relieve105010693relieve
reline65434353reli_ne
reliques1736903reliques
relive95120783reli_ve
remade94316983remad_e
remise84221953remi_se
repine85627813repi_ne
rerise64325633reri_se
resaddle10115223resaddle
resaid74517083resaid__
resale64025543res_ale
resalute857413resalute
rescale93215473rescale
rescore95616203rescore
rescued10410043res_cued
rescuer939033res_cuer
rescues9312753res_cues
reseau64216213reseau_
reseaus74012153reseaus
reseaux14326233reseaux
resecure1047183resecure
reseda739703resed_a
resedas839123resedas
resee54336333res__ee
reseize1639553reseize
reseizure18112833reseizure
reserve101011203reserve
reshape1249043reshape
reshave1338603reshave
reshine102816943reshine
reshoe92816483res_hoe
reshone102414163reshone
residence1268903residence
resident9313753resident
residers93311883residers
residing103015473residing
residuals10223803residuals
residuary1342653residuary
residuums1251903residuums
resift94017723resi_ft
resifted12310153resifted
resifts10378703resifts
resight11510643resight
resign74212583resi_gn
resigned1038863resigned
resigner937793resigner
resigns83910963resigns
resiled84621983resiled
resiles74026543resiles
resilin72913973resilin
resilver11337503resilver
resin54131053resi__n
resinate8316773resinate
resined84522653resined
resinous838503resinous
resins64528773resi_ns
resiny94617363resi_ny
resist64524533resi_st
resisted9312693resisted
resister8311653resister
resists74414923resists
resit54241043resi__t
resited85122423resited
resites74027793resites
resits64725563resi_ts
resituate948613resituate
resized174614903resized
resizes164216843resizes
reslate73520593reslate
resod64720053resod__
resodded1136353resodded
resods74116303resod_s
resole64624183res_ole
resolute868513resolute
resolve103910983resolve
respace11310913respace
respade1039573respade
respire9411543respire
respite9513033respite
respoke134311283respoke
restage83316193restage
restate73824883restate
restful1038623restful
restitute947753restitute
restive10315933restive
restoke116113903restoke
restore75822983restore
restudy1144763restudy
restyle1038763restyle
resume8313783res_ume
resurge839073resurge
reticle94112623reticle
reticule1049303reticule
retie55735303reti__e
retile65929673reti_le
retime85321803reti_me
retinae75517333retinae
retine66237333reti_ne
retinued95210823retinued
retinues85113153retinues
retire64927013reti_re
retiree75019083retiree
retitle73913093retitle
revalue1038153revalue
revenue1039533revenue
revile94921613revi_le
revise94019743revi_se
revive124914823revi_ve
revue81114453re__vue
rewiden1137533rewiden
rewire95421413rewi_re
rexine134719443rexi_ne
ride55945133r__id_e
ridge75018673r__idge
risible937923risible
risque15227453ris_que
rusine63916593rusi_ne
seaside839693seasid_e
side55444493__sid_e
sidhe95315103__sidhe
sidle65124033__sidle
upside9289803upsid_e
ureide7310363ure_id_e
vendue10419013ve_ndue
vesicae12177703vesicae
vesicle12217923vesicle

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272126.48620664.0
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.95225703.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.