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

167 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
suber7492450(None) 
cuber95222531cuber
saber75330241saber
sober74822411sober
subers85722641subers
suer45334031su_er
super74924481super
surer54833101surer
tuber75420681tuber
amber94523212amber
auger64922472auger
buyer105013092buyer
caber95126832caber
cube85830212cube_
cubeb115814662cubeb
cubed105519702cubed
cubers105318352cubers
cubes95028162cubes
cumber124016702cumber
curber104517052curber
curer75030752curer
cuter74728232cuter
cyber124910382cyber
dauber94112012dauber
dubber113814552dubber
dumber114414172dumber
duper85519002duper
ember95516802ember
fiber104921132fiber
fubar1039922fubar
fumer105918232fumer
giber85417702giber
huger94914872huger
jiber145115702jiber
jube136322782jube_
jubes145420742jubes
liber74723622liber
lubber104214622lubber
lube64731562lube_
lubed85319892lubed
lubes74727992lubes
luger65322082luger
lumber103817772lumber
lurer54625312lurer
muser76024122muser
muter74525542muter
nuder66416832nuder
number103913222number
omber95316442omber
outer55633302outer
pubes94423402pubes
puler74826622puler
purer75127902purer
queer143712812queer
rubber104715792rubber
rube65532012rube_
rubel75416832rubel
rubes74928412rubes
rubier84814742rubier
ruder65320542ruder
ruer46127562ru_er
ruler54923342ruler
sabe66140572sabe_
sabed86526812sabed
sabers85224732sabers
sabes76437462sabes
sabir75917002sabir
sabre74821502sabre
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
saucer84314102saucer
sauger74316252sauger
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seder64826762seder
seer45547042s_eer
ser36752402s__er
serer55935512serer
sever85426052sever
sewer84426222sewer
sheer84726892sheer
shier85428942shier
shoer84722162shoer
shyer114714782shyer
siker95326032siker
siver85728612siver
sizer145521812sizer
skier95119592skier
slier54827242slier
slubber113010762slubber
slumber113811002slumber
slyer85515122slyer
sneer54919952sneer
snubber11277732snubber
sobber104016592sobber
sobers85218862sobers
somber103714002somber
sorer56236592sorer
sourer63620212sourer
souter64225922souter
sower85229312sower
speer74623902speer
spier75728032spier
steer55423862steer
suaver93014232suaver
sub55445552sub__
suba64926602sub_a
subah106015212subah
subas74724072subas
subbed114116672subbed
subdeb1137522subdeb
subduer10107032subduer
suberic11312212suberic
suberin9314562suberin
sublet82827242sublet
subnet82520932subnet
suborn8310012suborn
subpar1048662subpar
subs66037122sub_s
subsea82610192subsea
subsere9311442subsere
subset83122582subset
subtler92910842subtler
suburb1037162suburb
subvert12312892subvert
subzero1835612subzero
sucker124120662sucker
sucre75019102sucre
sudor6312622sudor
sudser73511282sudser
sue35651462su_e_
sued56537932su_ed
suers55128482su_ers
sues46247652su_es
suet46754822su_et
suffer124314512suffer
sugar6312912sugar
suiter64121812suiter
sulker104015922sulker
summer104017712summer
sunder74019822sunder
supe65932762supe_
superb104410992superb
supers84622402supers
supes75628302supes
supper104115432supper
sure45447412sure_
surfer93515882surfer
surger74320092surger
sutler63718392sutler
sweer84918572sweer
taber73825822taber
tubber104313202tubber
tube65828662tube_
tubed85818042tubed
tubers85017032tubers
tubes74826452tubes
tuner56022682tuner
tuyer85414292tuyer
umber94617592umber
user45023002_user
usher84517762usher
usurer638102usurer
weber10313522weber

Search took 3 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.313570897.8
2DLD Change Limit538001671.70331591.3
3Display Results1671670.0463630.4
 (SQL Overall)1786911672.06286659.1
 
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.