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

213 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
sober7482240(None) 
saber75330241saber
sobber104016581sobber
sobers85218851sobers
somber103713991somber
sorer56236571sorer
sower85229311sower
suber74924501suber
amber94523212amber
bobber95016742bobber
bomber125014652bomber
boner75133082boner
borer75131272borer
bower107328182bower
boxer145016522boxer
caber95126832caber
cobber124116842cobber
coder86134212coder
comber125118502comber
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cover105430772cover
cower104531772cower
coyer105222842coyer
cuber95222532cuber
cyber124910382cyber
dobber114015412dobber
doer57734702do_er
doper86128392doper
doser66228562doser
doter65428622doter
dower95027702dower
dozer158419272dozer
ember95516802ember
fiber104921132fiber
foyer116416552foyer
giber85417702giber
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025162goner
goober93911742goober
hobber134114632hobber
hoer76533982ho_er
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hover115524132hover
isobar836142isobar
isomer8310152isomer
jiber145115702jiber
jobber173813352jobber
joker165715892joker
liber74723622liber
lobar7313012lobar
lobber104016602lobber
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
loner55431042loner
loper75129232loper
loser54728672loser
lover85526452lover
lower85830412lower
mobber123613462mobber
moper94925922moper
mover104220862mover
mower104523452mower
nobler83713452nobler
noter55025642noter
obe56638642_obe_
obes66036832_obes
obey96521302_obey
omber95316442omber
omer67028392_omer
osier53518012osier
over77227342_over
oyer75927652_oyer
poker115122882poker
poler74431792poler
poser75128772poser
power105325952power
prober104516072prober
robber103916532robber
robe65335642robe_
robed85323732robed
robes75133302robes
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
sabe66140572sabe_
sabed86526812sabed
sabers85224732sabers
sabes76437462sabes
sabir75917002sabir
sabre74821502sabre
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
saver84831252saver
sawer85026212sawer
sayer84926552sayer
scorer84818252scorer
scoter83815472scoter
seder64826752seder
seer45547042s_eer
ser36752402s__er
serer55935502serer
sever85426052sever
sewer84426212sewer
sheer84726892sheer
shier85428942shier
shoer84722152shoer
shover124515982shover
shower124315102shower
shyer114714782shyer
siker95326032siker
siver85728612siver
sizer145521812sizer
skier95119592skier
slier54827242slier
slobber11388902slobber
sloper84615912sloper
slower94016152slower
slyer85515122slyer
smoker124311692smoker
sneer54919952sneer
snorer64316762snorer
soaker105717532soaker
soaper84517872soaper
soar46838672so_ar
soarer64522242soarer
sob57857942sob__
soba64927922sob_a
sobas74424252sobas
sobbed113516262sobbed
sobbers114114252sobbers
sobeit8315342sobeit
sobered102912432sobered
soberer93110352soberer
soberly1236942soberly
sobs64941752sob_s
soccer1038542soccer
soever94412092soever
sofar86115492sofar
softer94015312softer
soke85436262soke_
sokes95031422sokes
solar55927342solar
solder73921342solder
sole46053672sole_
soled65835172soled
solei55624332solei
soles55547922soles
solver94016702solver
sombre10729472sombre
some66040382some_
sonar56523422sonar
sonder73623522sonder
sone46649982sone_
sones55444142sones
sooey84522432sooey
sooner64220462sooner
sopor74016492sopor
sorbed94916512sorbed
sorbet83924072sorbet
sore47059532sore_
sored66141782sored
sorel56231442sorel
sores55454282sores
sorner64720382sorner
sorter64425082sorter
sour45935892so_ur
sourer63620212sourer
souter64225922souter
sowar85821342sowar
sowed94933862sowed
sowers94923432sowers
speer74623902speer
spier75728032spier
steer55423862steer
stoker104417622stoker
stoner65823202stoner
stoper84320092stoper
storer64721672storer
stover94115642stover
subers85722642subers
suer45334032s_uer
super74924482super
surer54833092surer
sweer84918572sweer
swobber14336542swobber
taber73825822taber
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
tuber75420682tuber
umber94617592umber
unsober967632unsober
vomer105517382vomer
voter85121052voter
vower115220792vower
weber10313522weber
wooer84316692wooer
zoner144520342zoner

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 Limit538002131.72031279.1
3Display Results2132130.0633381.0
 (SQL Overall)1786912131.87695251.1
 
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.