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

478 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
scammer13361197(None) 
scammed14479541scammed
scammers14339771scammers
scamper134613161scamper
scummer13398751scummer
shammer144613141shammer
slammer113913031slammer
spammer133410431spammer
stammer116013341stammer
calmer105216932_calmer
camber124418472_camber
camper124722212_camper
clammer134211792clammer
crammer134010962crammer
cummer124414592_cummer
dammer114317932_dammer
gammer1112318332_gammer
hammer138120032_hammer
jammer174014132_jammer
mammer94218862_mammer
rammer103519652_rammer
scaler84321602sca_ler
scalier94316912scalier
scalper113912922scalper
scamped144711962scamped
scampers143611032scampers
scamster1235302scamster
scanner94411812scanner
scanter94215182scanter
scarcer113911372scarcer
scarer84524602sca_rer
scarfer124511082scarfer
scarier94017872scarier
scarper114814822scarper
scatter93815172scatter
scauper11379452scauper
schemer1477952schemer
schmeer1475362schmeer
scrammed1555002scrammed
scummed14347912scummed
scummers14277782scummers
scummier1445082scummier
seamer84223612sea_mer
seamier93114632seamier
shammed153911422shammed
shammers153710832shammers
shammes144312832shammes
shimmer143310872shimmer
simmer104115352s_immer
skimmer15327532skimmer
slammed123511102slammed
slammers123511222slammers
slimmer114211342slimmer
slummer113711202slummer
spammed14348522spammed
spammers14378692spammers
stammel11607532stammel
stammers123611522stammers
stamper113714392stamper
stemmer113210182stemmer
summer104017712s_ummer
swamper14349312swamper
swarmer1247802swarmer
swimmer14297652swimmer
yammer133713182_yammer
aimer75926823__aimer
amber94523203__amber
ameer75618983__ameer
armer76924443__armer
bammed133913243_bammed
beamier113411943beamier
blamer104417143bla_mer
brimmer13348803brimmer
bummer124014103_bummer
caber95126833_ca_ber
cabler104519173_cabler
cabmen123610653_cabmen
cadger105013893_cadger
cager85229223_ca_ger
cagier93715933_cagier
cahier113615773_cahier
cakier123115243_cakier
calker124917083_calker
caller85125483_caller
calmed114816383_calmed
cambers134017433_cambers
came87648753_ca_me_
camel96822803_ca_mel
cameo95924993_ca_meo
camera10313673_ca_mera
cames97047313_ca_mes
camlet104426583_camlet
cammie124615293_cammie
cammies134016473_cammies
camped134720233_camped
campers134220283_campers
campier133313273_campier
cancer104220923_cancer
caner75334773_ca_ner
canker124422523_canker
canner84625983_canner
canoer85121073_canoer
canter85230113_canter
caper94831623_ca_per
capper124421983_capper
carder94524183_carder
career85822243_career
carer74942333_ca_rer
carmen104019343_carmen
carper104923633_carper
carter84932273_carter
carver114420143_carver
caster85232573_caster
cater74840703_ca_ter
causer84117783_causer
caver105629063_ca_ver
chamber164011053chamber
chamfer17399853chamfer
champer163813403champer
charmer144913663charmer
chimer135517203_chimer
claimer11279883claimer
clamber133311733clamber
clammed14369963clammed
clammers143510683clammers
clammier1435843clammier
clamper134012993clamper
comber125118503_comber
comer95832693_c_omer
crammed143710123crammed
crammers14369343crammers
crimmer133310773crimmer
cumber124016703_cumber
cummers133713473_cummers
dammar11438903_dammar
dammed124214793_dammed
dammers123214273_dammers
damner95213433_damner
damper114117753_damper
dimmer114112613_dimmer
drammed13378073drammed
drummer12407503drummer
emmer94314463__emmer
escaper11368843esca_per
farmer115017373_farmer
flamer114919123fla_mer
flamier123112143flamier
flammed15377413flammed
foamer114714313foa_mer
foamier12339003foamier
framer114817443fra_mer
gamer84928943_ga_mer
gamier93617933_gamier
gammed124216163_gammed
gammers123214563_gammers
gammier123711193_gammier
glimmer12437713glimmer
glummer12417983glummer
grammar12406893grammar
gramme114210333gramme_
grammes123611323grammes
grimmer123510093grimmer
grummer12338783grummer
gummer114615453_gummer
hammed144116973_hammed
hammers144216053_hammers
hammier143510653_hammier
hamper134518653_hamper
harmer114719553_harmer
hemmer134112643_hemmer
hummer133615273_hummer
jammed183811503_jammed
jammers183710703_jammers
jammier18408023_jammier
krimmer15376873krimmer
lamber104418493_lamber
lamer75233703_la_mer
lammed113915623_lammed
limmer104314793_limmer
loamier9349163loamier
maimer104514593_maimer
mammee94417853_mammee
mammers104615693_mammers
mammet94319253_mammet
mammey124310893_mammey
mamzer19459833_mamzer
mummer93614543_mummer
namer75622103_na_mer
palmer105816543_palmer
pamper124316663_pamper
plummer13298523plummer
primmer134310163primmer
rammed113117303_rammed
rammers113715043_rammers
rammier112811023_rammier
reamer84325213rea_mer
recamier1237603recamier
rehammer1544653rehammer
rimmer103516033_rimmer
roamer84715163roa_mer
rummer104715483_rummer
saber75330243s_a_ber
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
same65245643s_a_me_
samek114915273s_a_mek
samiel8313333s_amiel
samlet84126563s_amlet
sampler113212013s_ampler
sander74828533s_ander
saner54334323s_a_ner
sanger74524563s_anger
sapper103822353s_apper
saucer84314103s_aucer
sauger74316253s_auger
saver84831253s_a_ver
sawer85026213s_a_wer
sawyer12438043s_awyer
sayer84926553s_a_yer
scabbed14408223scabbed
scabbier1435133scabbier
scabies11613333scabies
scalar83612433sca_lar
scalare93311833scalare
scalded11409763scalded
scale74629143sca_le_
scaled94822443sca_led
scalers93817263sca_lers
scales84529313sca_les
scalped124411993scalped
scalpel11377713scalpel
scalpers123710863scalpers
scam85932353sca_m__
scamming15328543scamming
scammony1743023scammony
scamp115717313sca_m_p
scampered1635233scampered
scamperer1544623scamperer
scampi12469103sca_mpi
scampies1439323scampies
scamps125014173sca_mps
scams94423973sca_m_s
scamsters1334983scamsters
scanned104110893scanned
scanners10379703scanners
scanted104114393scanted
scantier10309983scantier
scape96921843sca_pe_
scaped115519553sca_ped
scapes105122263sca_pes
scar66434203sca___r
scarce104013633scarce_
scare75334463sca_re_
scared95227293sca_red
scareder1135783scareder
scarers94618503sca_rers
scares85033003sca_res
scarey115016983sca_rey
scarfed134711183scarfed
scarfers13408463scarfers
scarlet91516943scarlet
scarped124314393scarped
scarpers124712513scarpers
scarred104512633scarred
scarrier10298453scarrier
scarted104816123scarted
scarves124511623scarves
scathe114414993scathe_
scathed134012643scathed
scathes124515713scathes
scatted103512773scatted
scatters103612753scatters
scattier10267583scattier
scaupers12378173scaupers
scaur75814903sca__ur
scepter1138353scepter
scheme1379633scheme_
schemed1577753schemed
schemers1576703schemers
schemes1489663schemes
schmear1484043schmear
schmeers1574833schmeers
schmoe13328333schmoe_
schmoes14308543schmoes
scimiter1236143scimiter
sclaffer16112653sclaffer
scoffer15317023scoffer
scolder103210333scolder
scooper113812033scooper
scooter93312863scooter
scorer84818253sc_orer
scorner9259763scorner
scoter83815473sc_oter
scourer93910433scourer
scouter93313323scouter
scowder13286853scowder
scowler12248173scowler
scrambler15165043scrambler
scramjet1945033scramjet
scraper114513403scraper
scrapper1466953scrapper
scrawler1345883scrawler
screamer12267873screamer
screwer124410063screwer
scriber113910963scriber
scrimper1455753scrimper
scrummed1554313scrummed
scuffer15328883scuffer
sculker13318323sculker
sculler99812153sculler
scummy15265223scumm_y
scunner9358243scunner
scupper1367423scupper
scutter93512173scutter
sealer63928963sea_ler
seamed94823883sea_med
seamen84518563sea_men
seamers94719433sea_mers
seamster1037143seamster
searer65432023sea_rer
seater64534153sea_ter
seemer84418043s_eemer
shader104218763sha_der
shadier113111153shadier
shaker134319463sha_ker
shakier143411153shakier
shalier103116423shalier
shame105726703sha_me_
shamed125120213sha_med
shames114726223sha_mes
shammas14358713shammas
shammied16265543shammied
shammies15259673shammies
shammos14307203shammos
shammy16388503shamm_y
shaper114119933sha_per
sharer95025483sha_rer
sharker144313813sharker
sharper124312703sharper
shatter103615693shatter
shaver123718913sha_ver
shimmed15338583shimmed
shimmers15269413shimmers
shimmery18265253shimmery
simmers113314613s_immers
simper103616293s_imper
skanker10268483skanker
skater105015483ska_ter
skimmed16306053skimmed
skimmers16296453skimmers
slabber113311393slabber
slacker133915293slacker
slaker104219273sla_ker
slalomer1045033slalomer
slander84015443slander
slapper113512463slapper
slasher104515323slasher
slater64429183sla_ter
slather103816063slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
slimier93212013slimier
slimmed12368473slimmed
slimmers12369633slimmers
slumber113811003slumber
slummed12359273slummed
slummers12358933slummers
slummier1235473slummier
smacker153410583smacker
smaller93410333smaller
smarmier1235033smarmier
smarter94113133smarter
smasher123911013smasher
smatter93613333smatter
snacker133112603snacker
snakier112810003snakier
snapper113512073snapper
snarer64620843sna_rer
snarler73610633snarler
soaker105717533soa_ker
soaper84517873soa_per
soapier93411713soapier
soarer64522243soa_rer
socager10107703soca_ger
somber103713993s_omber
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spaller92713473spaller
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613073sparger
sparker133914353sparker
sparser94311483sparser
spasmed12296993spasmed
spatter94016523spatter
spawner12347363spawner
spumier1137903spumier
stabber113610153stabber
stabler94014933stabler
stacker134416263stacker
staffer13299093staffer
stager74821343sta_ger
stagger94212383stagger
stagier83513443stagier
staider83912613staider
stainer73614923stainer
staler64025823sta_ler
stalker113912253stalker
stamen84115943sta_men
stammels12495563stammels
stammered1444643stammered
stammerer1344063stammerer
stamped124812813stamped
stampers124211593stampers
stander84316163stander
stapler93913623stapler
starer64027363sta_rer
starker114114693starker
starter73817873starter
starver104611993starver
stater64427553sta_ter
stayer94516483sta_yer
steamer93313093steamer
steamier1048303steamier
stemmed12278153stemmed
stemmers12378443stemmers
stemmery15334693stemmery
stemmier1245253stemmier
stomper114111223stomper
strummer1234783strummer
stummed12348553stummed
stumper113610093stumper
suaver93014233sua_ver
summed114014043s_ummed
summers113616503s_ummers
summery14329413s_ummery
swabber14297963swabber
swager104013613swa_ger
swagger12389333swagger
swagmen1334973swagmen
swamies123712063swamies
swamped15498443swamped
swampers15317473swampers
swampier1544593swampier
swanker14369483swanker
swapper14359703swapper
swarmed1367483swarmed
swarmers1346323swarmers
swasher134011503swasher
swather134213593swather
swatter104113323swatter
swayer125210973swa_yer
swimmers15276693swimmers
swimmier15174313swimmier
sycamore1542763sycamore
tamer75230103_ta_mer
tamper104618513_tamper
trammed123810713trammed
trammel11357663trammel
tramper113812153tramper
trimmer113610833trimmer
vamper134212653_vamper
warmer113816733_warmer
whammed18345133whammed
yammers143410323_yammers

Search took 7 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.1561145455.1
2DLD Change Limit1340274786.61020276.4
3Display Results4784780.1732763.0
 (SQL Overall)1786914786.93925751.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.