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

166 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
slides7392218(None) 
elides74420691elides
glides84518861glides
sides65838361s_ides
slices84022851slices
slide64725411slide_
slider73918361slider
sliders83515221sliders
slimes84722041slimes
slipes84921411slipes
abides94719892abides
aides65336602_aides
alines65735222alines
amides95722662amides
asides75118872asides
azides165113802azides
bides85536772_bides
blades95221252blades
blites84721212blites
bolides10515072bolides
brides94423512brides
chides124620472chides
clades94920462clades
climes104720002climes
clines84926042clines
elide64922642elide_
elided84814672elided
elites66027122elites
eludes75417682eludes
flies85630712fli_es
flites95122442flites
glades84820342glades
gledes84915132gledes
glide74521592glide_
glided94513902glided
glider84614262glider
gliders94811842gliders
glimes94717522glimes
grides84422362grides
guides84118282guides
halides113416662halides
hides95129422_hides
ides57734232__ides
imides94515342imides
irides74519122irides
lades65141272_lades
lidos65219882_lidos
lids56336452_lid_s
lies46454192_li_es
likes96231902_likes
limes75636502_limes
lines57054572_lines
lives86133192_lives
lodes66436912_lodes
ludes65728852_ludes
nides65229132_nides
oldies7314422oldies
olives94313952olives
oxides14109692oxides
plies74526512pli_es
prides94324182prides
rides66140812_rides
sades65239892s_ades
saices84221802saices
saids65328852said_s
salines74029412salines
seidel7311082seidel
seidels838392seidels
seines65029902seines
seises64026712seises
seizes154317532seizes
shades105924532shades
shies86136552shi_es
shines95028912shines
shires95225572shires
shives124921412shives
sices75637272s_ices
side55444482s_ide_
sided74825952s_ided
sidles74721152s_idles
sikes96236082s_ikes
silds65520522sild_s
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skids104615322skid_s
skies95026832ski_es
skites104418042skites
skives134113942skives
slakes104021882slakes
slates64934062slates
slaves95023022slaves
sledges94511572sledges
sleds64418852sled_s
slice74925822slice_
sliced94416312sliced
slicer84117602slicer
slicers94114922slicers
slicks124816112slicks
slid55828982slid__
slidden935152slidden
slier54827242sli_er
sliest66621952sli_est
slieves10378962slieves
slime74925752slime_
slimed94915122slimed
slims75423652sli_ms
slings74618012slings
slinks104315152slinks
slipe75626132slipe_
sliped95417062sliped
slips76023722sli_ps
slits56128852sli_ts
sliver94116592sliver
slivers104115252slivers
sloes54728872sl_oes
sloids73712692sloid_s
slopes84820452slopes
sludges93811992sludges
slues54527172sl_ues
sluices959072sluices
slypes114410482slypes
smidges11448192smidges
smiles84522292smiles
smites83921922smites
snide64318722snide_
snider74413912snider
snidest8310912snidest
snipes83917392snipes
solider82912452solider
solidest9310382solidest
solids74116402solid_s
solidus8338112solidus
sondes74922872sondes
spades94222582spades
spices104326032spices
spider94516802spider
spiders103914412spiders
spies76037622spi_es
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
splices113914382splices
splines94718892splines
spodes94817432spodes
stades74626242stades
sties55132982sti_es
stiles64328772stiles
stimes85920572stimes
stipes84524052stipes
strides84520392strides
suedes73918112suedes
suites63727402suites
sulfides1238052sulfides
swedes102711892swedes
swipes114114332swipes
swives123915182swives
tides64830152_tides
tildes74513962tildes
wides94832822_wides

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 Filter178691825510.346516448.0
2DLD Change Limit825511662.57632046.2
3Display Results1661660.0463608.7
 (SQL Overall)1786911662.96860205.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.