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

153 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
sneer5491995(None) 
seer45547041s_eer
sheer84726891sheer
sneers64016171sneers
sneery93610411sneery
speer74623901speer
steer55423861steer
sweer84918571sweer
ameer75618982ameer
anear55420322anear
anger66225872anger
beer65635992_beer
cheer105420382cheer
deer56739022_deer
emeer74815362emeer
ender64325862ender
enter54726382enter
fleer86020772fleer
freer86021242freer
infer84215032infer
inker94421092inker
inner54920622inner
inter55028492inter
jeer115426462_jeer
knee85323602knee_
kneed104612052kneed
kneel95012032kneel
knees95114872knees
leer46239352_leer
near45236502_near
nee36657782_nee_
need54934152_need
neem67328082_neem
neep65728312_neep
never86218642_never
newer85717462_newer
peer66238352_peer
queer143712812queer
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
sander74828532sander
saner54334322saner
sanger74524562sanger
saver84831252saver
sawer85026212sawer
sayer84926552sayer
sear47353842s_ear
seder64826752seder
see35772262s_ee_
seed55549482s_eed
seeder74320772seeder
seek85935482s_eek
seeker103615362seeker
seel45042982s_eel
seem65438562s_eem
seemer84418042seemer
seen46943122s_een
seep66540342s_eep
seers55136382s_eers
sees45361052s_ees
sender73824412sender
sene46848052sene_
senor53822792senor
ser36752402s__er
sere46153472s_ere
serer55935502serer
sever85426052sever
sewer84426212sewer
shear85424832shear
sheen85023312sheen
sheep105321522sheep
sheers94322402sheers
sheet84836952sheet
shewer124515102shewer
shier85428942shier
shoer84722152shoer
shyer114714782shyer
sieur5911892sieur
siker95326032siker
singer74227302singer
sinker103620902sinker
sinner64320592sinner
sinter63625922sinter
siver85728612siver
sizer145521812sizer
skee85431472skee_
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skewer13519602skewer
skier95119592skier
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slier54827242slier
slyer85515122slyer
smear74416392smear
smeek114912352smeek
snare54429982snare
snarer64620842snarer
sneak96016172sneak
sneaker112910452sneaker
sneap75514822sneap
sneck114713662sneck
sned56026052sn_ed
sneds65715352sneds
sneered83113972sneered
sneerer73512312sneerer
sneesh945892sneesh
sneeze15318522sneeze
sneezer16237962sneezer
sneezy18345272sneezy
snell54517302snell
sneller73512842sneller
snider74413912snider
sniper84413642sniper
snore55424952snore
snorer64316762snorer
snye77115492snye_
snyes85012752snyes
sober74822402sober
soever94412092soever
sonder73623522sonder
sorer56236572sorer
sower85229312sower
spear75821062spear
speed85526622speed
speel74420762speel
speers85019952speers
speir75315362speir
spewer115112142spewer
spier75728032spier
steed66024942steed
steek95418002steek
steel55721992steel
steep76020702steep
steers63820982steers
stere55328542stere
suber74924502suber
suer45334032s_uer
sunder74019822sunder
super74924482super
surer54833092surer
swear85316852swear
sweep104715722sweep
sweet85330522sweet
under64624212under
veer76229572_veer
veneer94511692veneer
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.0931921408.6
2DLD Change Limit538001531.68631909.8
3Display Results1531530.0463326.1
 (SQL Overall)1786911531.82597912.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.