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

296 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
scabby153550(None) 
cabby145314561_cabby
shabby1635801shabby
swabby1634351swabby
blabby1234812blabby
cobby145516412_cobby
crabby15346752crabby
cubby145212122_cubby
flabby1634572flabby
gabby135512952_gabby
grabby14336182grabby
scab85926712sca_b_
scabbed14408222scabbed
scabbily1763942scabbily
scabble13168652scabble
scabs94818642sca_bs
scaly104718722sca_ly
scanty114014662scanty
scarey115016982scarey
scarry116311182scarry
scary105222592sca_ry
scatty115310652scatty
scrabbly17164622scrabbly
scrubby1642802scrubby
slobby1334802slobby
snobby1334402snobby
snubby1344532snubby
squabby2343282squabby
stably113314122stably
stubby1345042stubby
suably112814532suably
tabby125213892_tabby
yabby15389752_yabby
abba810522653__abba
abbe87627193__abbe
abbey125714933__abbey
ably99725133__ably
aby810238063__a_by
baby116723683_ba_by
blebby1233743blebby
bobby114814663_bobby
bubby115013933_bubby
cab78355403_ca_b_
cabal95222153_cabal
cabbagy1744013_cabbagy
cabbed135416263_cabbed
cabbie122913353_cabbie
caber95126833_caber
cabin94820943_cabin
cable95329913_cable
cabob114616813_cabob
cabobs124311893_cabobs
cabs86739423_ca_bs
caddy125414023_caddy
cadgy125210783_cadgy
cagey115917823_cagey
cagy106321993_ca_gy
cakey145517273_cakey
caky136222443_ca_ky
campy145116183_campy
candy115119823_candy
canny105817693_canny
canty105226803_canty
carb85143163_carb_
carbo94923843_carbo
carboy134914183_carboy
carbs96031463_carbs
carny105822923_carny
carry105823783_carry
casky144512683_casky
catty104520413_catty
cavy125920003_ca_vy
cay87155983_ca__y
chubby1844123chubby
clubby1534683clubby
cobb106422003_cobb_
cobbs115013993_cobbs
colby124415063_colby
corby125018533_corby
dauby115211223_dauby
dobby136013633_dobby
drably123511613drably
gaby107123193_ga_by
globby1434683globby
grubby14324503grubby
hobby155913733_hobby
hubby155011403_hubby
knobby1732713knobby
knubby1742783knubby
lamby125114843_lamby
lobby125113923_lobby
nearby11356053nearby
nobby125513463_nobby
nubby125011033_nubby
rabbi93113183_rabbi
ribby12419683_ribby
rubby124413863_rubby
sab56563203s_a_b_
sabal75422483s_abal
sabbat10314713s_abbat
sabbed114518083s_abbed
sabe66140573s_a_be
sabed86526813s_abed
saber75330243s_aber
sabes76437463s_abes
sabin74924953s_abin
sabir75917003s_abir
sable74732163s_able
sabot7931783s_abot
sabra75317853s_abra
sabre74821503s_abre
sabs66643743s_a_bs
sacbut10811943sacbut
sadly94519123s_adly
saggy105917463s_aggy
sagy85327083s_a_gy
salably121610743salably
sally85129713s_ally
salty85524383s_alty
samba95618773s_amba
sambo95118013s_ambo
sandy94221133s_andy
sappy125413473s_appy
sarky125521783s_arky
sassy85813813s_assy
satay84718463s_atay
saucy104615163s_aucy
saury84317223s_aury
savoy114713883s_avoy
savvy14497503s_avvy
say67264763s_a__y
scabbard1544203scabbard
scabbier1435133scabbier
scabbing15277193scabbing
scabbled15156303scabbled
scabbles14167983scabbles
scabies11613333scabies
scad75725773sca__d
scads85419963sca_ds
scag76626893sca__g
scags85520973sca_gs
scalably15166703scalably
scalar83612433scalar
scald84818123sca_ld
scalds94813693scalds
scale74629143sca_le
scaled94822443scaled
scaler84321603scaler
scales84529313scales
scall74420373sca_ll
scalls84218203scalls
scalp95217983sca_lp
scalps104315233scalps
scam85932353sca__m
scamp115717313sca_mp
scampi12469103scampi
scamps125014173scamps
scams94423973sca_ms
scan65530453sca__n
scans74625103sca_ns
scant79735073sca_nt
scantly12419553scantly
scants85219723scants
scape96921843sca_pe
scaped115519553scaped
scapes105122263scapes
scar66434203sca__r
scarab10310063scarab
scarabs1137293scarabs
scarce104013633scarce
scare75334463sca_re
scared95227293scared
scarer84524613scarer
scares85033003scares
scarf105427143sca_rf
scarfs114714683scarfs
scarify1537443scarify
scarily12311703scarily
scarp95724103sca_rp
scarph13429603scarph
scarps104718603scarps
scars75433533sca_rs
scart76139773sca_rt
scarts85321493scarts
scat65848373sca__t
scathe114414993scathe
scats75930603sca_ts
scatt76030093sca_tt
scatts85914663scatts
scaup95515993sca_up
scaups105411933scaups
scaur75814903sca_ur
scaurs85512053scaurs
schizy23115043schizy
scrabble14196993scrabble
scraggy14304583scraggy
scrappy16234473scrappy
scrawly15197193scrawly
scrawny15213943scrawny
screwy14659463screwy
scribbly17143623scribbly
scribe104613533scribe
scrub94914203scrub_
scrubs104210313scrubs
scry96017763sc__ry
scuba94211593sc_uba
scubas103710223scubas
scummy15265223scummy
scurfy14338763scurfy
scurry11419593scurry
scurvy14386103scurvy
scuzzy1933083scuzzy
seabag938473seabag
seabed95017693seabed
seamy105921273sea_my
seaway12309993seaway
shabbily1873903shabbily
shady125416513sha_dy
shaggy14478043shaggy
shaky154616843sha_ky
shaley123714993shaley
shaly114322863sha_ly
shammy16388503shammy
shamoy14379913shamoy
shandy134710033shandy
shanny124110093shanny
shanty124715123shanty
sharny124711833sharny
sharpy145211033sharpy
shay107133343sha__y
shrubby1742363shrubby
sibb85921423s_ibb_
sibbs96211903s_ibbs
sickbay1843723sickbay
sizably2136613sizably
skanky12476963skanky
slab67133763sla_b_
slabbed12409503slabbed
slabber113311393slabber
slabbery15375773slabbery
slabs75322643sla_bs
slaggy11438793slaggy
slangy105411393slangy
slanty95114843slanty
slatey95417063slatey
slaty86523153sla_ty
slavey124011803slavey
slay76436383sla__y
smarmy13629353smarmy
smarty115013793smarty
snaggy11488053snaggy
snakey135011273snakey
snaky125113913sna_ky
snappy1366103snappy
snarky134210843snarky
snarly93815003snarly
snazzy1734013snazzy
soapy106114783soa_py
sociably1546793sociably
spacey136212533spacey
spacy125415623spa_cy
sparky154511523sparky
sparry115111303sparry
spay96631663spa__y
stab67329933sta_b_
stabbed123510373stabbed
stabber113610153stabber
stable83921643stable
stabs76221383sta_bs
stagey105915583stagey
staggy115510393staggy
stagy96618893sta_gy
stalky13499303stalky
standby1334423standby
starry94911673starry
stay78333723sta__y
stubbly1444473stubbly
suable83920553suable
swab96825313swa_b_
swabbed15367403swabbed
swabber14297963swabber
swabbie1484333swabbie
swabs105817273swa_bs
swampy16437233swampy
swamy136714403swa_my
swanky16447973swanky
swanny12336823swanny
swarty125812383swarty
sway107128233swa__y
tubby124511403_tubby
usably11288983usably
useably1287393useably
viably14199833viably
vocably17157153vocably
wabbly16348363_wabbly
webby1537153_webby

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162964.90622975.1
3Display Results2962960.0933182.8
 (SQL Overall)1786912965.37233263.4
 
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.