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

210 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
spied8542771(None) 
espied9359781espied
pied75035361_pied
shied96125491shied
siped84927681siped
skied104417751skied
spaed85522271spaed
sped76031491sp_ed
speed85526621speed
spiced115218311spiced
spiel74623911spiel
spier75728031spier
spies76037621spies
spiked134915551spiked
spiled94621991spiled
spined95423941spined
spired94921861spired
spited94820441spited
spued84918471spued
stied65723031stied
aped78538152ap_ed
aspired1068172aspired
biped104718832biped
copied114618572copied
cried84624292cried
died66137852_died
dried75321382dried
espies83716802espies
flied96519432flied
fried95322912fried
gied64631982_gied
hied85434042_hied
ivied94710522ivied
lied55838092_lied
oped76230152op_ed
opined95113852opined
opted84914272opted
ped66751522_p_ed
peed76239182_peed
pie55457402_pie_
pier66035292_pier
pies66949602_pies
piked125623312_piked
piled85232992_piled
pined85935322_pined
piped105123162_piped
pled75231432_pled
plied85118592plied
pried84426862pried
riped85226432riped
sabed86526812sabed
said55742112sai_d
sailed74327762sailed
sained75424242sained
saned65636272saned
sapid84720932sapi_d
sapped114422012sapped
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scried95817312scried
seed55549482s_eed
seined74023062seined
seised74218122seised
seized164313652seized
sered65737292sered
sewed95325162sewed
sexed136618542sexed
shed86536152s_hed
shiel811023772shiel
shield106212972shield
shier85428942shier
shies86136552shies
shined104620782shined
shoed95723012shoed
shred98125612shred
side55444492s_ide
sided74825952sided
sild55030582s_ild
sipe67341042sipe_
sipes76036952sipes
sipped113720632sipped
sired66134282sired
sited65130742sited
sized155519242sized
skeed105018982skeed
skid95720932ski_d
skier95119592skier
skies95026832skies
skiey125012892skiey
skited114313482skited
skived14429892skived
skyed13529922skyed
sled55334372s_led
sliced94416312sliced
slid55828982sli_d
slide64725412slide
slier54827242slier
slimed94915122slimed
sliped95417062sliped
slued64220512slued
smiled93716432smiled
sned56026052s_ned
snide64318722snide
sniped94913482sniped
soiled73822472soiled
soled65835172soled
sopited104211062sopited
sopped114819902sopped
sored66141782sored
sowed94933862sowed
spaced114517252spaced
spade84423322spade
spaded103816752spaded
spae65034322spae_
spaes76029972spaes
spared95427492spared
spayed124213612spayed
spec85821972sp_ec
speedo94011992speedo
speeds94316052speeds
speedy1218410792speedy
speel74420762speel
speer74623902speer
speil75618642speil
speiled104412122speiled
speir75315362speir
speired103811102speired
spend85619332spend
spew95421872sp_ew
spewed125512332spewed
spic85227432spi_c
spica94717942spica
spice95528812spice
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spick134519072spick
spics94123242spics
spicy125417712spicy
spider94516802spider
spieled104811882spieled
spiels85317952spiels
spiered104412462spiered
spiers84421742spiers
spiff133616402spiff
spiffed16257102spiffed
spik105419712spi_k
spike114922842spike
spiker124315662spiker
spikes124520712spikes
spikey155411332spikey
spiks114117472spiks
spiky146014112spiky
spile75230082spile
spiles84227912spiles
spill74821162spill
spilled103613622spilled
spilt75532222spilt
spin66231302spi_n
spine76534422spine
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spins75327982spins
spiny104921302spiny
spire75828692spire
spirea84015632spirea
spirem104214162spirem
spires84628112spires
spirt75032952spirt
spirted103913072spirted
spiry105017352spiry
spit65545082spi_t
spite75430662spite
spites84127332spites
spits74429552spits
spitted103912702spitted
spitz166017972spitz
spiv95917792spi_v
spivs105114242spivs
spliced124310592spliced
splined105013112splined
spode84617702spode
spoiled104811352spoiled
spoked134413892spoked
spored94821792spored
spread9312532spread
spree74830862spree
sprier84119062sprier
spud75818492sp_ud
spue66025522spue_
spues75025382spues
spumed114711542spumed
steed66024942steed
sties55132982sties
stiped94517072stiped
styed95815482styed
sued56537932s_ued
suited74019422suited
supped114415702supped
swiped123811092swiped
swived133610632swived
tied55535212_tied
tried65026912tried
upped103715162upped
vied86328632_vied
wiped114722082wiped
wried95518562wried

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.843211970.3
2DLD Change Limit538002106.0338917.6
3Display Results2102100.1231707.3
 (SQL Overall)1786912106.99925530.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.