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

397 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
swarmers134632(None) 
swarmer1247801swarmer_
warmers124514291_warmers
armers85520272__armers
awarders1245072awarders
charmers154211332charmers
farmers124315262_farmers
harmers124116592_harmers
scammers14339772scammers
scarers94618512scar_ers
scarfers13408462scarfers
scarpers124712512scarpers
seamers94719432sea_mers
shammers153710842shammers
sharers104720622shar_ers
sharkers154011052sharkers
sharpers133810942sharpers
slammers123511222slammers
snarers74216662snar_ers
snarlers8298752snarlers
soarers74118092soar_ers
spammers14378692spammers
sparers94519612spar_ers
spargers11389732spargers
sparkers144111312sparkers
stammers123611522stammers
starers74522312star_ers
starkers123712392starkers
starters83714772starters
starvers11459642starvers
swabbers15316742swabbers
swagers114211022swa_gers
swaggers13407222swaggers
swampers15317472swampers
swappers15358082swappers
swarmed1367482swarme_d
swarms116112172swarm__s
swashers14389532swashers
swathers144512082swathers
swatters113911792swatters
swayers13398852swa_yers
swearers11328582swear_ers
swervers1455212swervers
swimmers15276692swimmers
warders113416812_warders
warmer113816732_warmer_
warners103315562_warners
warpers123413582_warpers
wormers124012572_wormers
aimers84621913__aimers
armer76924443__armer_
armets84918353__armets
armors85017813__armors
awaiters1146643awaiters
awardees1243993awardees
awarder1135893awarder_
barbers114317503_barbers
barkers134318513_barkers
barters94223033_barters
bearers94619593bear_ers
bedwarmers1842703bedwarmers
blamers115314213bla_mers
boarders11408623boarders
carders104820353_carders
careers95218783_careers
carers85133963_car_ers
carpers114521253_carpers
carters95327253_carters
carvers124817543_carvers
chargers144011323chargers
charmer144913663charmer_
charters134115583charters
claimers12298743claimers
clammers143510693clammers
crammers14369353crammers
dammers123214273_dammers
darers75921873_dar_ers
darners83815773_darners
darters84017603_darters
dewormers15255193dewormers
disarmers1246943disarmers
dormers104313923_dormers
dwarfer1433683dwarfer_
dwarves1434463dwarve_s
earners74016453_earners
farcers124713443_farcers
farers95924053_far_ers
farmer115017373_farmer_
fearers104815273fear_ers
firmers124711443_firmers
flamers124616363fla_mers
foamers123812103foa_mers
formers128217953_formers
framers125113823fra_mers
gamers94420833_ga_mers
gammers123214563_gammers
garners83815983_garners
garters84218233_garters
guarders1035883guarders
hammers144216063_hammers
harmer114719553_harmer_
harpers124916203_harpers
hearers104319783hear_ers
hoarders12307433hoarders
jammers183710703_jammers
larders83516943_larders
larkers113014513_larkers
learners8398153learners
legwarmers1671853legwarmers
maimers113813043_maimers
mammers104615693_mammers
markers133516103_markers
marrers93414313_marrers
namers84517333_na_mers
ormers84316143__ormers
palmers113513623_palmers
parers85530743_par_ers
parkers133816873_parkers
parsers94118153_parsers
pearlers1039033pearlers
quarters173110453quarters
rammers113715043_rammers
reamers94221083rea_mers
rearers74323563rear_ers
rewarders13226453rewarders
roamers93713463roa_mers
roarers73812743roar_ers
sabers85224733s_a_bers
sackers133820223s_ackers
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sameks12409323s_a_meks
sanders84025943s_anders
sangers84421943s_angers
sappers113518903s_appers
sardars83112903s_ardars
sarees65329943s_ar_ees
sarges75128593s_arge_s
sarment9318763s_arment
sarments10311963s_arments
sarsars73512143s_arsars
sarsens7311393s_arsens
sartors7314973s_artors
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scalers93817263sca_lers
scalpers123710863scalpers
scammer133611973scammer_
scampers143611033scampers
scanners10379703scanners
scarcer113911373scarcer_
scarer84524613scar_er_
scares85033003scar_e_s
scarfer124511083scarfer_
scarier94017873scarier_
scarless10189053scarless
scarlets10178573scarlets
scarper114814823scarper_
scarves124511623scarve_s
scatters103612753scatters
scaupers12378173scaupers
schemers1576713schemers
scorers94115323scor_ers
scorners10228493scorners
scrapers125510533scrapers
scummers14277783scummers
sealers74323553sea_lers
seamer84223613sea_mer_
searchers14197353searchers
searer65432023sear_er_
seaters74028943sea_ters
seemers93814333s_eemers
sergers83815633s_ergers
servers103214833s_ervers
shaders115915553sha_ders
shakers144015563sha_kers
shames114726223sha_me_s
shammer144613143shammer_
shammes144312833shamme_s
shapers124016893sha_pers
sharer95025483shar_er_
shares95236413shar_e_s
sharker144313813sharker_
sharpens13377813sharpens
sharper124312703sharper_
shatters113313913shatters
shavers134115093sha_vers
shearers113911323shear_ers
shimmers15269413shimmers
shirkers15319583shirkers
simmers113314613s_immers
skankers11316483skankers
skaters113512963ska_ters
skimmers16296463skimmers
skirters12337243skirters
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slalomers1144553slalomers
slammer113913033slammer_
slanders94014013slanders
slappers123710953slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
slimmers12369633slimmers
slummers12358933slummers
smackers16318713smackers
smarmier1235033smarmier_
smarms105712533smarm__s
smartens10286663smartens
smarter94113133smarter_
smashers13339593smashers
smatters104011713smatters
smearers10308623smear_ers
smirkers14316353smirkers
snackers143010223snackers
snappers123510173snappers
snarer64620843snar_er_
snares65329033snar_e_s
snarler73610633snarler_
snorers74313803snor_ers
snorters83410583snorters
soakers114114953soa_kers
soapers93715923soa_pers
soarer64522243soar_er_
sorners73416873s_orners
sorters74221133s_orters
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammer133410433spammer_
spankers14369863spankers
spanners103710773spanners
sparer84524963spar_er_
spares84834553spar_e_s
sparger103613083sparger_
sparges104016343sparge_s
sparker133914363sparker_
sparklers15315643sparklers
sparser94311483sparser_
spatters103914703spatters
spawners13396493spawners
spearers103711143spear_ers
sporters103714063sporters
sprayers13367053sprayers
spurners10288493spurners
spurrers10338463spurrers
spurters103311703spurters
squarers17338023squar_ers
squirmers2053113squirmers
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stamens93411483sta_mens
stammels12495563stammels
stammer116013343stammer_
stampers124211603stampers
standers93514303standers
staplers103111203staplers
starer64027363star_er_
stares66038753star_e_s
starets73515923star_ets
starker114114693starker_
starless81610843starless
starlets81610083starlets
starter73817883starter_
startlers9236743startlers
starver104611993starver_
starves104614553starve_s
staters73922343sta_ters
stayers103813633sta_yers
steamers103410873steamers
stemmers12378443stemmers
stirrers8266943stirrers
storers75018683stor_ers
strafers11379913strafers
strayers113510143strayers
sugarers936303sugar_ers
summers113616503s_ummers
surfers103614133s_urfers
surgers83517483s_urgers
swabber14297963swabber_
swager104013613swa_ger_
swages104417073swa_ge_s
swagger12389333swagger_
swagmen1334973swagme_n
swales93920763swa_le_s
swamies123712063swa_mies
swamis114212293swa_m_is
swamper14349313swamper_
swamps135910263swa_m_ps
swanherd1533483swanherd
swanherds1642543swanherds
swanker14369483swanker_
swannery1433553swannery
swapper14359703swapper_
swarajes1843743swarajes
swarded1238153swarde_d
swards105415133swar__ds
sware85828213swar_e__
swarfs125612063swar__fs
swarm106218843swarm___
swarming1458223swarming
swarths13537323swar_ths
swartness1236113swartness
swasher134011513swasher_
swashes134714403swashe_s
swather134213603swather_
swathes134115513swathe_s
swatter104113323swatter_
swayer125210973swa_yer_
swearer10349953swear_er_
sweaters113811063sweaters
sweepers13348163sweepers
swelters113110193swelters
swerver1365733swerver_
swerves1377533swerve_s
swifters14277483swifters
swiggers13337123swiggers
swillers11299113swillers
swimmer14297653swimmer_
swingers123710423swingers
swishers14328053swishers
swithers144310533swithers
swobbers15355593swobbers
swooners11336863swooners
swoopers13317523swoopers
swotters11448483swotters
tamers84224033_ta_mers
tearers75218233tear_ers
termers95414503_termers
thwarters1542843thwarters
twangers12226063twangers
twirlers11274303twirlers
variers103712663_variers
wadders123812443_wadders
waders109120643_wa_ders
wadmels1334303_wadmels
wafers124316143_wa_fers
wafters134112813_wafters
wagers105122203_wa_gers
waggers124613083_waggers
wailers103916803_wailers
waiters104218623_waiters
waivers133410053_waivers
wakers134822493_wa_kers
walers94824463_wa_lers
walkers143411473_walkers
wames106432803_wa_me_s
wanders114221333_wanders
wankers144514713_wankers
wanters104420093_wanters
warblers13319103_warblers
wardens113711903_wardens
warder104020273_warder_
wares88250583_war_e_s
warier93722893_warier_
warless104015103_warless
warmakers1845633_warmakers
warmed124516893_warme_d
warmest123113033_warmest
warmness1337063_warmness
warms107726853_warm__s
warmths1583783_warmths
warmups1433813_warmups
warner93717223_warner_
warper114015583_warper_
warrens103810893_warrens
warslers11328073_warslers
washers134517523_washers
wasters104026593_wasters
waters95030633_wa_ters
wavers125022473_wa_vers
waxers164014303_wa_xers
wearers104615903wear_ers
wirers94617893_wir_ers
workers144612693_workers
wormer114514913_wormer_
yammers143410323_yammers
yarders113211593_yarders
yarners104312203_yarners
yearners11346373yearners

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.423422437.4
2DLD Change Limit1461623977.31019994.8
3Display Results3973970.1562544.9
 (SQL Overall)1786913977.88922650.7
 
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.