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

364 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
scammers1433977(None) 
scammer133611971scammer_
scampers143611031scampers
scummers14277781scummers
shammers153710841shammers
slammers123511221slammers
spammers14378691spammers
stammers123611521stammers
cambers134017442_cambers
campers134220292_campers
clammers143510692clammers
crammers14369352crammers
cummers133713482_cummers
dammers123214272_dammers
gammers123214562_gammers
hammers144216062_hammers
jammers183710702_jammers
mammers104615692_mammers
rammers113715042_rammers
scalers93817262sca_lers
scalpers123710862scalpers
scammed14479542scamme_d
scamper134613162scamper_
scamsters1334992scamsters
scanners10379702scanners
scarers94618512sca_rers
scarfers13408462scarfers
scarpers124712512scarpers
scatters103612752scatters
scaupers12378172scaupers
schemers1576712schemers
schmeers1574832schmeers
scummer13398752scummer_
seamers94719432sea_mers
shammer144613142shammer_
shammes144312832shamme_s
shimmers15269412shimmers
simmers113314612s_immers
skimmers16296462skimmers
slammer113913032slammer_
slimmers12369632slimmers
slummers12358932slummers
spammer133410432spammer_
stammels12495562stammels
stammer116013342stammer_
stampers124211602stampers
stemmers12378442stemmers
summers113616502s_ummers
swampers15317472swampers
swarmers1346322swarmers
swimmers15276692swimmers
yammers143410322_yammers
aimers84621913__aimers
ambers104519583__ambers
ameers84015573__ameers
armers85520273__armers
blamers115314213bla_mers
brimmers14287073brimmers
bummers133712443_bummers
cabers105023923_ca_bers
cablers114416713_cablers
cadgers114712003_cadgers
cagers95624193_ca_gers
cahiers123510673_cahiers
calkers134414693_calkers
callers94221963_callers
calmer105216933_calmer_
camber124418483_camber_
camels105217083_ca_mels
cameos105818003_ca_meos
camera10313693_ca_mera
cameras11313363_ca_meras
cames97047313_ca_me_s
camlets114314623_camlets
cammies134016483_cammies
camper124722213_camper_
cancers114018583_cancers
caners84629203_ca_ners
cankers134418753_cankers
canners93822663_canners
canoers94318373_canoers
canters94827733_canters
capers105428143_ca_pers
cappers134419403_cappers
carders104820353_carders
careers95218783_careers
carers85133963_ca_rers
carpers114521253_carpers
carters95327253_carters
carvers124817543_carvers
casters94729903_casters
caters85336503_ca_ters
causers94014793_causers
cavers115026843_ca_vers
chambers173410623chambers
chamfers18409223chamfers
champers173311623champers
charmers154211333charmers
chimers144515143_chimers
claimers12298743claimers
clambers144211293clambers
clammer134211793clammer_
clampers143211893clampers
combers134516623_combers
comers105328083_c_omers
crammer134010963crammer_
crimmers14298543crimmers
cumbers134515413_cumbers
cummer124414593_cummer_
dammars12308193_dammars
dammer114317933_dammer_
damners104112113_damners
dampers123915693_dampers
dimmers123811563_dimmers
drummers13316163drummers
emmers104013223__emmers
escapers12337413esca_pers
farmers124315263_farmers
flamers124616363fla_mers
foamers123812103foa_mers
framers125113823fra_mers
gamers94420833_ga_mers
gammer1112318333_gammer_
glimmers13396153glimmers
grammars13345943grammars
grammes123611323gramme_s
gummers123712203_gummers
hammer138120033_hammer_
hampers143616953_hampers
harmers124116593_harmers
hemmers143310843_hemmers
hummers143813063_hummers
jammer174014133_jammer_
krimmers16315673krimmers
lambers113817113_lambers
lampers113817333_lampers
limmers113413083_limmers
maimers113813043_maimers
mammees104411143_mammees
mammer94218863_mammer_
mammets103911113_mammets
mammeys13376723_mammeys
mamzers20409163_mamzers
mummers103712843_mummers
namers84517333_na_mers
palmers113513623_palmers
pampers133615933_pampers
rammer103519653_rammer_
reamers94221083rea_mers
recamiers1345513recamiers
rehammers1644503rehammers
rimmers113812883_rimmers
roamers93713463roa_mers
rummers113513653_rummers
sabers85224733s_a_bers
sackers133820223s_ackers
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sambars115113843s_ambars
samburs11369343s_amburs
sameks12409323s_a_meks
samiels939763s_amiels
samlets93813553s_amlets
samplers12299403s_amplers
sanders84025943s_anders
sangers84421943s_angers
sappers113518903s_appers
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scabies11613333scabie_s
scalares103210983scalares
scalars93711903sca_lars
scaler84321603sca_ler_
scales84529313sca_le_s
scalier94316913scalier_
scalpels12345883scalpels
scalper113912923scalper_
scamming15328543scamming
scammony1743023scammony
scamped144711963scampe_d
scampered1635233scampered
scamperer1544623scamperer
scamperers1643473scamperers
scampies1439333scampies
scamps125014173sca_m_ps
scams94423973sca_m__s
scamster1235303scamster_
scanner94411813scanner_
scanter94215183scanter_
scapes105122263sca_pe_s
scarcer113911373scarcer_
scarer84524613sca_rer_
scares85033003sca_re_s
scarfer124511083scarfer_
scarier94017873scarier_
scarless10189053scarless
scarlets10178573scarlets
scarper114814823scarper_
scars75433533sca___rs
scarves124511623scarve_s
scathes124515713scathe_s
scatter93815173scatter_
scauper11379453scauper_
scaurs85512053sca__urs
scepters1237793scepters
schemer1477963schemer_
schemes1489663scheme_s
schmears1584103schmears
schmeer1475363schmeer_
schmoes14308543schmoe_s
scimiters1345123scimiters
sclaffers17122523sclaffers
scoffers16286133scoffers
scolders11288993scolders
scoopers124210193scoopers
scooters103511033scooters
scorers94115323sc_orers
scorners10228493scorners
scoters93313813sc_oters
scourers10348533scourers
scouters103411323scouters
scowders14276233scowders
scowlers13257373scowlers
scramblers16183543scramblers
scramjets2052063scramjets
scrammed1555003scramme_d
scrapers125510533scrapers
scrappers1545863scrappers
scrawlers1434753scrawlers
screamers13236263screamers
screwers13358063screwers
scribers12307963scribers
scrimpers1554643scrimpers
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
scumless1254993scumless
scummed14347913scumme_d
scummier1445083scummier_
scunners10357303scunners
scuppers1446543scuppers
scutters103311023scutters
sealers74323553sea_lers
seamer84223613sea_mer_
seamier93114633seamier_
seamless10238723seamless
seamsters1136333seamsters
seaters74028943sea_ters
seemers93814333s_eemers
shaders115915553sha_ders
shakers144015563sha_kers
shames114726223sha_me_s
shammas14358723shamm_as
shammed153911423shamme_d
shammies15259693shammies
shammos14307203shamm_os
shapers124016893sha_pers
sharers104720623sha_rers
sharkers154011053sharkers
sharpers133810943sharpers
shatters113313913shatters
shavers134115093sha_vers
shimmer143310873shimmer_
shimmery18265253shimmery
simmer104115353s_immer_
simpers113014123s_impers
skankers11316483skankers
skaters113512963ska_ters
skimmer15327533skimmer_
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slalomers1144553slalomers
slammed123511103slamme_d
slanders94014013slanders
slappers123710953slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
slimmer114211343slimmer_
slumbers123110273slumbers
slummer113711203slummer_
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snackers143010223snackers
snappers123510173snappers
snarers74216663sna_rers
snarlers8298753snarlers
soakers114114953soa_kers
soapers93715923soa_pers
soarers74118093soa_rers
socagers1196363soca_gers
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammed14348523spamme_d
spankers14369863spankers
spanners103710773spanners
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawners13396493spawners
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stamens93411483sta_mens
stammel11607533stamme_l
stammered1444643stammered
stammerer1344063stammerer
stammerers1443133stammerers
stamper113714403stamper_
standers93514303standers
staplers103111203staplers
starers74522313sta_rers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343sta_ters
stayers103813633sta_yers
steamers103410873steamers
stemmer113210183stemmer_
stemmery15334693stemmery
stompers123610043stompers
strummers1333693strummers
stumpers12318313stumpers
summer104017713s_ummer_
summery14329413s_ummery
swabbers15316743swabbers
swagers114211023swa_gers
swaggers13407223swaggers
swamies123712063swamie_s
swamper14349313swamper_
swappers15358083swappers
swarmer1247803swarmer_
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853swa_yers
swimmer14297653swimmer_
sycamores1642873sycamores
tamers84224033_ta_mers
tampers113516743_tampers
trammels12295413trammels
trampers123210393trampers
trimmers12288913trimmers
vampers143111623_vampers
warmers124514293_warmers
yammer133713183_yammer_

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.420425454.8
2DLD Change Limit1461623646.45322650.2
3Display Results3643640.1402600.0
 (SQL Overall)1786913647.01325480.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.