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

236 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
spier7572803(None) 
pier66035291_pier
shier85428941shier
skier95119591skier
slier54827241slier
speer74623901speer
speir75315361speir
spicer104719311spicer
spider94516801spider
spied85427711spied
spiel74623911spiel
spiers84421741spiers
spies76037621spies
spiker124315661spiker
spire75828691spire
sprier84119061sprier
aper66336232ap_er
apter76120202apter
ashier94714832ashier
asper75520432asp_er
aspire8612122aspire
aspirer967902aspirer
bier65531832_bier
brier74527402brier
copier103722892copier
crier74724462crier
dopier93515922dopier
drier64423962drier
epimer10109152epimer
espied9359772espied
espies83716802espies
flier86023402flier
frier85225842frier
icier74313752icier
kier86526812_kier
lier45942462_lier
mopier103914782mopier
osier53518012osier
peer66238352_peer
per56353092_p_er
pie55457402_pie_
pied75035362_pied
piers75926332_piers
pies66949602_pies
piker115622842_piker
piper96523192_piper
pipier104913982pipier
plier75221282plier
prier75027762prier
rapier84019992rapier
raspier93110642raspier
riper74328402riper
ropier84118802ropier
saber75330242saber
safer84721812safer
sager65432052sager
sagier73717162sagier
sailer63526102sailer
saker95132022saker
saner54334322saner
sapper103822352sapper
sappier113613122sappier
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seder64826762seder
seepier92912012seepier
seer45547042s_eer
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
ser36752402s__er
serer55935512serer
sever85426052sever
sewer84426222sewer
sexier13310682sexier
sheer84726892sheer
shied96125492shied
shiel811023772shiel
shiers94921752shiers
shies86136552shies
shiner93820872shiner
shire84727132shire
shirr84716922shirr
shiver124517372shiver
shoer84722162shoer
shyer114714782shyer
sieur5911892s_ieur
siker95326032siker
sipe67341042sipe_
siped84927682siped
sipes76036952sipes
sipper103920992sipper
sir35746672s_i_r
sire46150412s_ire
siver85728612siver
sizer145521812sizer
sizier1514813392sizier
skied104417752skied
skiers104713702skiers
skies95026832skies
skiey125012892skiey
skirr94810542skirr
skiver134612102skiver
slicer84117602slicer
slider73918362slider
sliver94116592sliver
slyer85515122slyer
smiler83916682smiler
smiter83616412smiter
sneer54919952sneer
snider74413912snider
sniper84413642sniper
soapier93411712soapier
sober74822412sober
soppier112711582soppier
sorer56236592sorer
soupier93111752soupier
sower85229312sower
spacer104917792spacer
spacier114011632spacier
spader94317132spader
spae65034322spae_
spaed85522272spaed
spaes76029972spaes
spar65433302sp_ar
spare75135562spare
sparer84524962sparer
spear75821062spear
spec85821972sp_ec
sped76031492sp_ed
speed85526622speed
speel74420762speel
speers85019952speers
speil75618642speil
speirs85013232speirs
sperm93216022sp_erm
spew95421872sp_ew
spewer115112152spewer
sphere113313662sphere
sphery14318882sphery
spic85227432spi_c
spica94717942spica
spice95528812spice
spiced115218312spiced
spicers113815552spicers
spicery14499012spicery
spices104326032spices
spicey134414232spicey
spicier115112462spicier
spick134519072spick
spics94123242spics
spicy125417712spicy
spiders103914412spiders
spidery13308202spidery
spieler93111232spieler
spiels85317952spiels
spiered104412462spiered
spiff133616402spiff
spik105419712spi_k
spike114922842spike
spiked134915552spiked
spikers135311992spikers
spikes124520712spikes
spikey155411332spikey
spikier13369982spikier
spiks114117472spiks
spiky146014112spiky
spile75230082spile
spiled94621992spiled
spiles84227912spiles
spill74821162spill
spiller92914332spiller
spilt75532222spilt
spin66231302spi_n
spine76534422spine
spined95423942spined
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spinier93715162spinier
spinner93912262spinner
spinor839942spinor
spins75327982spins
spiny104921302spiny
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spires84628112spires
spirier93214072spirier
spirt75032952spirt
spiry105017352spiry
spit65545082spi_t
spite75430662spite
spited94820442spited
spites84127332spites
spits74429552spits
spitter94015182spitter
spitz166017972spitz
spiv95917792spi_v
spivs105114242spivs
splicer114710522splicer
spoiler93310682spoiler
spoor75016352spoor
spore75428592spore
spree74830862spree
spryer11418532spryer
spue66025522spue_
spued84918472spued
spues75025382spues
spumier1137902spumier
spur65321192sp_ur
steer55423862steer
stied65723032stied
sties55132982sties
stir45723252sti_r
stiver93915732stiver
suber74924502suber
suer45334032s_uer
suiter64121812suiter
super74924482super
supper104115432supper
surer54833102surer
sweer84918572sweer
sypher14317082sypher
tier44936142_tier
trier54328532trier
twier84713292twier
typier1137332typier
upper93714262upper
vier75428152_vier
viper105017302viper
waspier12259052waspier
wiper105421292wiper
wispier12249402wispier
wrier84521752wrier

Search took 2 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.300595636.7
2DLD Change Limit538002361.40338346.4
3Display Results2362360.0802950.0
 (SQL Overall)1786912361.783100219.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.