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 “swabber” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

394 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
swabber1429796(None) 
slabber113311391slabber
stabber113610151stabber
swabbed15367401swabbed
swabbers15316741swabbers
swobber14336541swobber
blabber10418922blabber
clabber134210112clabber
crabber133810732crabber
dabber114816962_dabber
drabber12438592drabber
fabber134814112_fabber
gabber114916602_gabber
grabber12389762grabber
jabber173713642_jabber
nabber104913542_nabber
sabbed114518082s_abbed
saber75330242s_a_ber
scabbed14408222scabbed
scabbier1435132scabbier
shabbier1535182shabbier
slabbed12409502slabbed
slabbers123610122slabbers
slabbery15375772slabbery
slobber11388902slobber
slubber113010762slubber
snubber11277732snubber
sobber104016592s_obber
stabbed123510372stabbed
stabbers12268732stabbers
stabler94014932stabler
swabbie1484332swabbie
swabbies15115712swabbies
swabby1634352swabb_y
swager104013612swa_ger
swagger12389332swagger
swamper14349312swamper
swanker14369482swanker
swapper14359702swapper
swarmer1247802swarmer
swasher134011512swasher
swather134213602swather
swatter104113322swatter
swayer125210972swa_yer
swobbed15335442swobbed
swobbers15355592swobbers
wabbler143511922_wabbler
yabber136111832_yabber
abbe87627193__abbe_
abbes96723523__abbes
abbey125714933__abbey
abler75624313__abler
amber94523213__amber
awaiter1057443awaiter
awarder1135893awarder
babbler104012823_babbler
babier103515573_babier
barber104419323_barber
bibber94613573_bibber
blabbed11357813blabbed
blabbers11308153blabbers
blubber10399293blubber
bobber95016743_bobber
brabbler11397373brabbler
cabbed135416263_cabbed
caber95126833_ca_ber
cabler104519173_cabler
camber124418483_camber
chamber164011063chamber
clabbers14359903clabbers
clamber133311743clamber
clobber13378163clobber
clubber13319593clubber
cobber124116843_cobber
crabbed14388873crabbed
crabbers14358753crabbers
crabbier14326803crabbier
cribber13367663cribber
dabbed124416143_dabbed
dabbers123813213_dabbers
dabbler124012153_dabbler
dauber94112013_dauber
dibber114614713_dibber
dobber114015423_dobber
drabbed13428723drabbed
drabbet12319573drabbet
drubber12357863drubber
dubber113814553_dubber
dwarfer1433683dwarfer
enabler9299363enabler
fabler116115813_fabler
fibber134811933_fibber
flabbier1534093flabbier
flubber14287713flubber
gabbed125216893_gabbed
gabbers124612833_gabbers
gabbier12379633_gabbier
gabbler124013303_gabbler
gibber114112863_gibber
glibber1235163glibber
grabbed13368643grabbed
grabbers13337883grabbers
grabbier13316653grabbier
grabbler13377693grabbler
grubber12417913grubber
hobber134114633_hobber
jabbed184213483_jabbed
jabbers183610583_jabbers
jibber174111243_jibber
jobber173813353_jobber
lamber104418493_lamber
libber104414013_libber
lobber104016603_lobber
lubber104214623_lubber
mobber123613463_mobber
nabbed115113613_nabbed
nabbers113710463_nabbers
rabbet103818653_rabbet
rabbler113514093_rabbler
rehabber1563153rehabber
ribber103515493_ribber
robber103916533_robber
rubber104715793_rubber
sabbat10314713s_abbat
sabe66140573s_a_be_
sabed86526813s_a_bed
sabers85224733s_a_bers
sabes76437463s_a_bes
sabir75917003s_a_bir
sable74732163s_able_
sables85026693s_ables
sabre74821503s_abre_
sabred95916533s_abred
sabres85520863s_abres
sacker125124843s_acker
sadder82916973s_adder
safer84721813s_a_fer
sager65432053s_a_ger
sagger84321073s_agger
sagier73717163s_agier
sailer63526103s_ailer
saker95132023s_a_ker
salter64325083s_alter
salver94617753s_alver
sambar103914163s_ambar
sambur10469503s_ambur
sander74828533s_ander
saner54334323s_a_ner
sanger74524563s_anger
sapper103822353s_apper
saucer84314103s_aucer
sauger74316253s_auger
saver84831253s_a_ver
sawer85026213s_a_wer
sawyer12438043s_awyer
sayer84926553s_a_yer
scabbard1544203scabbard
scabble13168653scabble
scabbled15156303scabbled
scabbles14167983scabbles
scabby1535503scabb_y
scabies11613333scabies
scaler84321603sca_ler
scalier94316913scalier
scalper113912923scalper
scammer133611973scammer
scamper134613163scamper
scanner94411813scanner
scanter94215183scanter
scarcer113911373scarcer
scarer84524613sca_rer
scarfer124511083scarfer
scarier94017873scarier
scarper114814823scarper
scatter93815173scatter
scauper11379453scauper
scrabbler15195203scrabbler
scriber113910973scriber
scrubber1434123scrubber
seabed95017693sea_bed
sealer63928963sea_ler
seamer84223613sea_mer
seamier93114633seamier
searer65432023sea_rer
seater64534163sea_ter
sewable121911173sewable_
shabby1635803shabb_y
shader104218763sha_der
shadier113111153shadier
shaker134319463sha_ker
shakier143411153shakier
shalier103116423shalier
shammer144613143shammer
shaper114119933sha_per
sharer95025483sha_rer
sharker144313813sharker
sharper124312703sharper
shatter103615703shatter
shaver123718913sha_ver
skanker10268483skanker
skater105015493ska_ter
slabbered14165083slabbered
slacker133915293slacker
slaker104219273sla_ker
slammer113913033slammer
slander84015443slander
slapper113512463slapper
slasher104515333slasher
slater64429183sla_ter
slather103816073slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
slobbers12398523slobbers
slobbery15375663slobbery
slobbier1254633slobbier
slubbed12339283slubbed
slubbers12349943slubbers
slumber113811003slumber
smacker153410583smacker
smaller93410333smaller
smarter94113133smarter
smasher123911023smasher
smatter93613333smatter
snacker133112603snacker
snakier112810003snakier
snapper113512073snapper
snarer64620843sna_rer
snarler73610633snarler
snibbed12325633snibbed
snobbery15514293snobbery
snobbier1234633snobbier
snubbed12347443snubbed
snubbers12326673snubbers
snubbier1244993snubbier
soaker105717533soa_ker
soaper84517873soa_per
soapier93411713soapier
soarer64522243soa_rer
sobbed113516263s_obbed
sobbers114114263s_obbers
sober74822413s__ober
somber103714003s_omber
sowable121610753sowable_
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spaller92713473spaller
spammer133410433spammer
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613083sparger
sparker133914363sparker
sparser94311483sparser
spatter94016523spatter
spawner12347363spawner
squabbier2242753squabbier
squabbler2242733squabbler
stable83921643stable_
stabled103514953stabled
stablers103611153stablers
stables93219073stables
stacker134416263stacker
staffer13299093staffer
stager74821343sta_ger
stagger94212393stagger
stagier83513443stagier
staider83912613staider
stainer73614923stainer
staler64025823sta_ler
stalker113912253stalker
stammer116013343stammer
stamper113714403stamper
stander84316163stander
stapler93913633stapler
starer64027363sta_rer
starker114114693starker
starter73817883starter
starver104611993starver
stater64427563sta_ter
stayer94516483sta_yer
stobbed12287493stobbed
stubbed12378083stubbed
stubbier1235353stubbier
suable83920553suable_
suaver93014233sua_ver
subbed114116673s_ubbed
suber74924503s__uber
swab96825313swa_b__
swabbing16246453swabbing
swabs105817273swa_b_s
swacked173110523swacked
swage94919563swa_ge_
swaged114212253swa_ged
swagers114211023swa_gers
swages104417073swa_ges
swagged13419153swagged
swaggers13407223swaggers
swagmen1334973swagmen
swale85221593swa_le_
swales93920763swa_les
swamies123712063swamies
swamped15498443swamped
swampers15317473swampers
swampier1544593swampier
swanherd1533483swanherd
swanked15359543swanked
swankier15225503swankier
swanned11358173swanned
swannery1433553swannery
swapped15429143swapped
swappers15358083swappers
swarded1238153swarded
sware85828213swa_re_
swarmed1367483swarmed
swarmers1346323swarmers
swashed144311363swashed
swashers14389533swashers
swashes134714403swashes
swathe125514113swathe_
swathed144611933swathed
swathers144512083swathers
swathes134115513swathes
swatted114110693swatted
swatters113911793swatters
swayed133510263swa_yed
swayers13398853swa_yers
swearer10349953swearer
sweater103712723sweater
sweatier1147033sweatier
sweeper12329373sweeper
sweer84918573sw__eer
sweeter103212003sweeter
sweller103012463sweller
swelter103711173swelter
swerver1365733swerver
swifter13318053swifter
swigger12338453swigger
swiller103211663swiller
swimmer14297653swimmer
swinger113812563swinger
swisher13369523swisher
swither133710993swither
swooner10358673swooner
swooper12389173swooper
swotter10399473swotter
tabbed114215363_tabbed
taber73825823_ta_ber
tubber104313203_tubber
twanger11327433twanger
wabble133714843_wabble
wabbled153311443_wabbled
wabblers15398993_wabblers
wabbles144013993_wabbles
wabblier15375493_wabblier
wabbly16348363_wabbly
wacker154920123_wacker
wadder114215483_wadder
wader95325363_wa_der
wafer114417643_wa_fer
wafter124114613_wafter
wager95925053_wa_ger
wagger113616013_wagger
wailer93720323_wailer
waiter94321253_waiter
waiver124212713_waiver
waker125526593_wa_ker
waler84229263_wa_ler
walker133913993_walker
wander104423713_wander
wanier93920683_wanier
wanker134219973_wanker
wanner94019623_wanner
wanter94423053_wanter
warbler123211463_warbler
warder104020273_warder
warier93722893_warier
warmer113816733_warmer
warner93717223_warner
warper114015583_warper
washer124720393_washer
waster95228943_waster
water84733313_wa_ter
watter93221983_watter
waver115025703_wa_ver
wavier124613083_wavier
waxer154317483_wa_xer
waxier16439903_waxier
webbed1436433_webbed
webbier1445423_webbier
weber10313523_w_eber
wobbler14329823_wobbler
yabbers14389353_yabbers

Search took 9 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 Filter1786911340270.436409841.7
2DLD Change Limit1340273947.50017870.3
3Display Results3943940.1432755.2
 (SQL Overall)1786913948.07922118.0
 
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.