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

188 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
speer7462390(None) 
peer66238351_peer
seer45547041s_eer
sheer84726891sheer
sneer54919951sneer
spear75821061spear
speed85526621speed
speel74420761speel
speers85019951speers
speir75315361speir
spewer115112151spewer
spier75728031spier
steer55423861steer
sweer84918571sweer
ameer75618982ameer
apeek114711872apeek
aper66336232ap_er
apter76120202apter
asper75520432asp_er
beer65635992_beer
cheer105420382cheer
deer56739022_deer
emeer74815362emeer
epee64628502epee_
epees75219832epees
fleer86020772fleer
freer86021242freer
jeer115426462_jeer
leer46239352_leer
leper74820742leper
opener83910992opener
pear69745232_pear
pee56066512_pee_
peed76239182_peed
peek106031432_peek
peel65535612_peel
peen65938082_peen
peep85833692_peep
peers75130272_peers
peery105719442_peery
pees65257372_pees
per56353092_p_er
pere66450262_pere
peter74427592_peter
pier66035292_pier
queer143712812queer
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
sapper103822352sapper
saver84831252saver
sawer85026212sawer
sayer84926552sayer
sear47353842s_ear
seder64826762seder
see35772262s_ee_
seed55549482s_eed
seeder74320772seeder
seek85935482s_eek
seeker103615362seeker
seel45042982s_eel
seem65438562s_eem
seemer84418042seemer
seen46943122s_een
seep66540342s_eep
seers55136382s_eers
sees45361052s_ees
ser36752402s__er
sere46153472s_ere
serer55935512serer
sever85426052sever
sewer84426222sewer
shear85424832shear
sheen85023312sheen
sheep105321522sheep
sheers94322402sheers
sheet84836962sheet
shewer124515112shewer
shier85428942shier
shoer84722162shoer
shyer114714782shyer
sieur5911892sieur
siker95326032siker
sipper103920992sipper
siver85728612siver
sizer145521812sizer
skee85431472skee_
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skewer13519612skewer
skier95119592skier
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slier54827242slier
slyer85515122slyer
smear74416392smear
smeek114912352smeek
sneers64016172sneers
sneery93610412sneery
sober74822412sober
soever94412092soever
sorer56236592sorer
sower85229312sower
spacer104917792spacer
spader94317132spader
spae65034322spae_
spaed85522272spaed
spaes76029972spaes
spar65433302sp_ar
spare75135562spare
sparer84524962sparer
speak114618672speak
speaker133311212speaker
spean74620512spean
spearer93913662spearer
spears84019472spears
spec85821972sp_ec
speck135115652speck
specs96916672specs
specter113111732specter
sped76031492sp_ed
speech1347562speech
speeder103811072speeder
speedo94011992speedo
speeds94316052speeds
speedy1218410792speedy
speels85116392speels
speered103614812speered
speil75618642speil
speirs85013232speirs
spell75020302spell
speller95415142speller
spelt75430192spelt
spelter94113702spelter
spencer113610972spencer
spend85619332spend
spender103713692spender
spent75532832spent
sperm93216022sperm
spew95421872sp_ew
spewed125512332spewed
spewers124210662spewers
spews105015922spews
sphere113313662sphere
sphery14318882sphery
spicer104719312spicer
spider94516802spider
spied85427712spied
spiel74623912spiel
spieler93111232spieler
spiers84421742spiers
spies76037622spies
spiker124315662spiker
spire75828692spire
spleen8310262spleen
spoor75016352spoor
spore75428592spore
spree74830862spree
sprees85620642sprees
sprier84119062sprier
spryer11418532spryer
spue66025522spue_
spued84918472spued
spues75025382spues
spur65321192sp_ur
steed66024942steed
steek95418002steek
steel55721992steel
steep76020702steep
steers63820982steers
stere55328542stere
suber74924502suber
suer45334032s_uer
super74924482super
supper104115432supper
surer54833102surer
swear85316852swear
sweep104715722sweep
sweet85330522sweet
sypher14317082sypher
upper93714262upper
veer76229572_veer
weer75535092_weer

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.310576422.6
2DLD Change Limit538001881.59633709.3
3Display Results1881880.0464087.0
 (SQL Overall)1786911881.95291542.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.