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

204 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
swobbers1535559(None) 
slobbers12398521slobbers
sobbers114114261s_obbers
swabbers15316741swabbers
swobber14336541swobber_
bobbers103614282_bobbers
clobbers14397512clobbers
cobbers134114752_cobbers
dobbers123513252_dobbers
hobbers143512342_hobbers
jobbers182911132_jobbers
lobbers113713942_lobbers
mobbers133610922_mobbers
robbers112814162_robbers
slabbers123610122slabbers
slobber11388902slobber_
slobbery15375662slobbery
slubbers12349942slubbers
snobbery15514292snobbery
snubbers12326672snubbers
sobber104016592s_obber_
sobers85218862s_o_bers
stabbers12268732stabbers
swabber14297962swabber_
swobbed15335442swobbe_d
swooners11336862swooners
swoopers13317522swoopers
swotters11448482swotters
wobblers15327882_wobblers
bibbers103911353_bibbers
blabbers11308153blabbers
blubbers11408143blubbers
bobber95016743_bobber_
bobbery13438353_bobbery
bombers134512593_bombers
clabbers14359903clabbers
clobber13378163clobber_
clubbers14378583clubbers
cobber124116843_cobber_
cobblers14359593_cobblers
combers134516623_combers
crabbers14358753crabbers
cribbers14306443cribbers
dabbers123813213_dabbers
dibbers124013173_dibbers
dobber114015423_dobber_
drubbers13386033drubbers
dubbers124011823_dubbers
fibbers144510603_fibbers
flubbers15346893flubbers
gabbers124612833_gabbers
gibbers124710983_gibbers
gobbets12327643_gobbets
gobblers13308343_gobblers
goobers10219623_goobers
grabbers13337883grabbers
grubbers13316203grubbers
hobber134114633_hobber_
hobblers15308513_hobblers
jabbers183610583_jabbers
jibbers18449703_jibbers
jobber173813353_jobber_
jobbery21366013_jobbery
libbers113812833_libbers
lobber104016603_lobber_
lobbyers1533193_lobbyers
lubbers113913723_lubbers
mobber123613463_mobber_
nabbers113710463_nabbers
nobblers12318563_nobblers
ombers104214403__ombers
probers113514583pro_bers
ribbers113913183_ribbers
robber103916533_robber_
robbery14348283_robbery
rubbers113913193_rubbers
sabers85224733s__abers
scoffers16286133scoffers
scolders11288993scolders
scoopers124210193scoopers
scooters103511033scooters
scorers94115323sco_rers
scorners10228493scorners
scoters93313813sco_ters
scourers10348533scourers
scouters103411323scouters
scowders14276233scowders
scowlers13257373scowlers
scribers12307963scribers
scrubbers1543373scrubbers
shockers17319463shockers
shoers94518333sho__ers
shooters112811583shooters
shoppers153010763shoppers
shouters113510623shouters
shovers134613003sho_vers
showers134612683sho_wers
skibobbers1751073skibobbers
slabber113311393slabber_
slabbery15375773slabbery
slobbered14144223slobbered
slobberer13153443slobberer
slobberers14152883slobberers
slobbier1254633slobbier_
sloggers10418783sloggers
slopers94213093slo_pers
slotters84012403slotters
slubber113010763slubber_
slumbers123110273slumbers
smokers13389323smo_kers
smolders11287193smolders
smothers13349933smothers
snobberies1444083snobberies
snobbier1234633snobbier_
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snorers74313803sno_rers
snorters83410583snorters
snubber11277733snubber_
soakers114114953s_oakers
soapers93715923s_oapers
soarers74118093s_oarers
sobbed113516263s_obbe_d
sober74822413s_o_ber_
soccers1138393s_occers
solders83517773s_olders
solvers104414253s_olvers
somber103714003s_omber_
sonders83820713s_onders
sooners73916643s_ooners
soothers113913433soothers
sorbets93012513s_orbets
sorners73416873s_orners
sorters74221133s_orters
souters74422603s_outers
sowers94923443s_o_wers
spoilers10238633spoilers
spongers1137603spongers
spoofers13307323spoofers
spoolers10349363spoolers
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
stabber113610153stabber_
stablers103611153stablers
stobbed12287493stobbe_d
stockers143411073stockers
stokers114515183sto_kers
stompers123610043stompers
stoners74817953sto_ners
stookers12449793stookers
stoopers103711303stoopers
stopers94217373sto_pers
stoppers123910593stoppers
storers75018683sto_rers
stovers103713733sto_vers
subers85722643s__ubers
swabbed15367403swabbe_d
swabbies15115713swabbies
swagers114211023sw_agers
swaggers13407223swaggers
swampers15317473swampers
swappers15358083swappers
swarmers1346323swarmers
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853sw_ayers
swearers11328583swearers
sweaters113811063sweaters
sweepers13348163sweepers
swelters113110193swelters
swervers1455213swervers
swifters14277483swifters
swiggers13337123swiggers
swillers11299113swillers
swimmers15276693swimmers
swingers123710423swingers
swishers14328053swishers
swithers144310533swithers
swobbing16235173swobbing
swobs104910893swo_b__s
swooner10358673swooner_
swooper12389173swooper_
swotter10399473swotter_
throbbers1643173throbbers
tubbers113411253_tubbers
twofers1364053two_fers
wabblers15398993_wabblers
webers11310943_w_ebers
wobbler14329823_wobbler_
wobbles143412433_wobbles
wolfers13409633_wolfers
wolvers13349313_wolvers
wonders113315993_wonders
wonners104312813_wonners
wooers93712443_wo_oers
woofers133810583_woofers
woolers104214023_woolers
workers144612693_workers
wormers124012573_wormers
wowsers13488763_wowsers
yabbers14389353_yabbers

Search took 8 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 Filter1786911461620.440406115.9
2DLD Change Limit1461622047.01320841.6
3Display Results2042040.0802550.0
 (SQL Overall)1786912047.53323721.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.