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

475 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
smearer9411040(None) 
searer65432021s_earer
shearer104414691shearer
smeared104510621smeared
smearers10308621smearers
smearier1036951smearier
spearer93913661spearer
swearer10349951swearer
bearer85323912_bearer
besmearer1343172besmearer
clearer93710822clearer
dearer74822802_dearer
fearer94820182_fearer
hearer94323652_hearer
meager94515202_meager
meaner84617842_meaner
merer75126232_me_rer
nearer64618892_nearer
rearer64928912_rearer
scarer84524612s_carer
sealer63928962s_ealer
seamer84223612s_eamer
seared75232842s_eared
seater64534162s_eater
serer55935512s_e_rer
sharer95025482s_harer
sheared114516012sheared
shearers113911322shearers
sheerer103813852sheerer
smarter94113132sm_arter
smear74416392smea__r
smears84714432smear_s
smeary114110802smear_y
smeller94212792smeller
smelter93311912smelter
snarer64620842s_narer
sneaker112910452sneaker
sneerer73512312sneerer
soarer64522242s_oarer
sparer84524962s_parer
speaker133311212speaker
speared104314422speared
spearers103711142spearers
squarer163410662squarer
starer64027362s_tarer
stealer72913982stealer
steamer93313092steamer
steerer73113632steerer
sugarer837322sugarer
swearers11328582swearers
sweater103712722sweater
tearer64822902_tearer
wearer94319412_wearer
afeared1176833afeared
ameer75618983ame__er
amender10349613amender
amercer1146373amercer
aneared8512743aneared
barer74535803__barer
beader94623793_beader
beaker125520693_beaker
bearers94619593_bearers
beater84729393_beater
beaver114819253_beaver
besmeared1443433besmeared
besmearers1442833besmearers
bleaker133510533bleaker
bleared104211253bleared
blearier1037333blearier
bleater94515303bleater
breaker133912923breaker
carer74942333__carer
cheaper144010583cheaper
cheater124816963cheater
cheerer123511763cheerer
cleaner93712303cleaner
cleared103612463cleared
clearers10349303clearers
cleaver124110803cleaver
comparer143611363comparer
creamer113714093creamer
creaser94415743creaser
darer65230793__darer
deader84220473_deader
deafer104114813_deafer
dealer74122143_dealer
demurer1037873demurer
dreamer104110843dreamer
drearier9297923drearier
eager65526973__eager
eared65139503__eared
earner63617223__earner
eater54639843__eater
emeer74815363eme__er
emender10649843emender
empaler11288353empaler
farer86733143__farer
feared106320433_feared
fearers104815273_fearers
feater95224053_feater
fuehrer1332973fuehrer
geared85317743_geared
gleamer10328513gleamer
gleaner8379773gleaner
greaser83913083greaser
greater84416493greater
header104422543_header
healer94221803_healer
heaper114119523_heaper
hearers104319783_hearers
heater94828303_heater
heaver124819673_heaver
imager9108123im_ager
imaret81121233im_aret
impairer1244863impairer
impaler11298393impaler
imparter12357543imparter
impurer1136483impurer
jeerer13389933_jeerer
kneader1275893kneader
leader74824653_leader
leaker104620073_leaker
leaner64022193_leaner
leaper88118943_leaper
learier73415663_learier
learner7319383_learner
leaser65322673_leaser
leaver94321513_leaver
macer912126943_m_acer
maker114127813_m_aker
mare64759333_m_are_
mares76457633_m_ares
marker124420393_m_arker
marrer83716673_marrer
maser75029973_m_aser
mater74438863_m_ater
mazer165722423_m_azer
meagre9349323_meagre_
mealier93015903_mealier
meander1049973_meander
meaners94415243_meaners
measurer1035953_measurer
meated94222403_meated
meatier93214613_meatier
meeker12359983_meeker
meeter83616503_meeter
melder93915813_melder
melter83520113_melter
member12258853_member
menacer112610883_menacer
mender93520793_mender
mercer105214203_mercer
mere67244443_me_re_
meres75143573_me_res
merger95016483_merger
merrier92612303_merrier
metamer1139613_metamer
meter75130323_me_ter
metier83517693_metier
metre74821303_metre_
metred95315143_metred
metres85121563_metres
mewler113510233_mewler
moaner84415113_moaner
neared75119813_neared
neater64424313_neater
parer75839903__parer
pearler9310373_pearler
pearter9412743_pearter
pleader103511763pleader
pleaser93912343pleaser
pleater93916333pleater
preaver121011613preaver
preparer12169643preparer
queerer16106503queerer
rarer54731703__rarer
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
reared75930013_reared
rearers74323563_rearers
reaver94524733_reaver
remaker133813173remaker
remarker14178493remarker
roarer63914333_roarer
saber75330243s__aber
safer84721813s__afer
sager65432053s__ager
saker95132023s__aker
saner54334323s__aner
saree55044663s__aree
savager1137133savager
saver84831253s__aver
savorer1057883savorer
sawer85026213s__awer
sayer84926553s__ayer
scaler84321613s_caler
scarcer113911373s_carcer
scare75334463s_care_
scared95227293s_cared
scarers94618513s_carers
scares85033003s_cares
scarey115016983s_carey
scarfer124511083s_carfer
scarier94017873s_carier
scarper114814823s_carper
scepter1138373scepter
schmeared1743053schmeared
scorer84818263s_corer
scourer93910433scourer
scraper114513423scraper
screamer12267883screamer
seabed95017693s_eabed
seafarer1144843seafarer
sealed74328363s_ealed
sealers74323553s_ealers
sealery104011053s_ealery
seamed94823883s_eamed
seamen84518563s_eamen
seamers94719433s_eamers
seamier93114633s_eamier
sear47353843s_ea__r
search113312423s_earch
searcher13209103s_earcher
searest73322023s_earest
sears54744913s_ear_s
seated75131063s_eated
seaters74028943s_eaters
secret8325063s_ecret
securer958253securer
sedater83713633sedater
seder64826763s_e_der
seeder74320773s_eeder
seedier83513633seedier
seeker103615363s_eeker
seemer84418043s_eemer
seepier92912013seepier
seer45547043s_e__er
seiner64622483s_einer
seiser65318343s_eiser
seizer154114573s_eizer
seller63824603s_eller
semester1038903semester
sempre102710093sempre_
sender73824413s_ender
sere46153473s_e_re_
sered65737293s_e_red
seres55448893s_e_res
serger73819743s_erger
server94917713s_erver
setter64023723s_etter
sever85426053s_e_ver
severer103511563severer
sewer84426223s_e_wer
sexier13310683s_exier
shader104218763s_hader
shaker134319463s_haker
shaper114119933s_haper
share86437083s_hare_
shared105829063s_hared
sharers104720623s_harers
shares95236413s_hares
sharker144313813s_harker
sharper124312703s_harper
shaver123718913s_haver
sheafed14388973sheafed
shear85424833shea__r
shears93820903shear_s
sheather1458233sheather
sheave124514003sheave_
sheaved143411633sheaved
sheaves134412973sheaves
shedder12339323shedder
sheer84726893she__er
sheered113515463sheered
sheeter103814913sheeter
sheller103515893sheller
shelter103214963shelter
shelver134211063shelver
shewer124515113she_wer
shmear1176933shmea__r
shmears1277073shmear_s
shoaler102610083shoaler
simperer1237173simperer
skater105015493s_kater
skeane104611373skeane_
skeanes113610713skeanes
skeeter113410413skeeter
skelter113610003skelter
skewer13519613ske_wer
slaker104219273s_laker
slater64429183s_later
slaver94419613s_laver
slayer93916333s_layer
sleave94714153sleave_
sleaved113611133sleaved
sleaves103813203sleaves
sleaze152611863sleaze_
sleazes162810333sleazes
sleazier1735123sleazier
sledder9399203sledder
sleeker11339823sleeker
sleeper93211563sleeper
slender83413603slender
smacker153410583smacker
smaller93410333smaller
smarm95517603sm_ar_m
smarmier1235033sm_armier
smarms105712533sm_arms
smarmy13629353sm_army
smart75834093sm_ar_t
smarted105012613sm_arted
smarten9348863sm_arten
smarts86218003sm_arts
smarty115013793sm_arty
smasher123911023smasher
smatter93613333smatter
smaze165012933sm_aze_
smazes174311663sm_azes
smeariest1138123smeariest
smearing113511753smearing
smeek114912353sme__ek
smeeked14287223smeeked
smelled103511863smelled
smellers10329773smellers
smellier1036813smellier
smelted10399093smelted
smelters103310513smelters
smeltery13274963smeltery
smerk115412723sme_r_k
smerked14327283smerked
smerks12449713sme_rks
smiler83916683sm_iler
smirker13327423smirker
smiter83616413sm_iter
smoker124311693sm_oker
smokier1356703smokier
smolder10327753smolder
smother123510213smother
smugger11327053smugger
snare54429983s_nare_
snared74824553s_nared
snarers74216663s_narers
snares65329033s_nares
snarler73610633s_narler
sneaked12329693sneaked
sneakers12308643sneakers
sneakier1245143sneakier
sneaped10338813sneaped
sneer54919953sne__er
sneered83113973sneered
sneerers8309803sneerers
sneerier878103sneerier
sneezer16237963sneezer
sneller73512853sneller
snorer64316763s_norer
soaker105717533s_oaker
soaper84517873s_oaper
soared74324293s_oared
soarers74118093s_oarers
soberer93110353soberer
socager10107703socager
soever94412093soe_ver
solacer93011103solacer
sorer56236593s__orer
sourer63620213s_ourer
spacer104917793s_pacer
spader94317133s_pader
spare75135563s_pare_
spared95427493s_pared
sparers94519613s_parers
spares84834553s_pares
sparger103613083s_parger
sparker133914363s_parker
sparser94311483s_parser
speakers14299453speakers
speaned103411523speaned
spear75821063spea__r
spearmen1234853spearmen
spears84019473spear_s
specter113111733specter
speeder103811073speeder
speer74623903spe__er
speered103614813speered
speired103811103speired
speller95415153speller
spelter94113703spelter
spencer113610973spencer
spender103713693spender
spewer115112153spe_wer
sprayer12369043sprayer
spreader1137483spreader
spurrer93710223spurrer
square154513363square_
squared173610563squared
squarers17338033squarers
squares163714463squares
squeaker2184883squeaker
squealer17115603squealer
stager74821343s_tager
staler64025823s_taler
stare54440263s_tare_
stared75429873s_tared
starers74522313s_tarers
stares66038753s_tares
starker114114693s_tarker
starter73817883s_tarter
starver104611993s_tarver
stater64427563s_tater
stayer94516483s_tayer
steaded92811673steaded
steadier937313steadier
stealers83412213stealers
steamed103712143steamed
steamers103410873steamers
steamier1048303steamier
stearic939423stearic
stearin7312003stearin
steeper93812773steeper
steer55423863ste__er
steered83615253steered
steerers82511353steerers
stemmer113210183stemmer
stepper113010853stepper
stere55328543ste_re_
stereo65317913ste_reo
steres63929533ste_res
sterner7411913sterner
stirrer7338233stirrer
storer64721673s_torer
strafer103912463strafer
strayer104312503strayer
streaker12229483streaker
streamer10239513streamer
suaver93014233s_uaver
subarea939413subarea
sugared938583sugared
sugarers936303sugarers
sugarier937393sugarier
surer54833103s__urer
svelter10359673svelter
swager104013613s_wager
sware85828213s_ware_
swarmer1247803s_warmer
swayer125210973s_wayer
swear85316853swea__r
swears94114073swear_s
sweated113411543sweated
sweaters113811063sweaters
sweatier1147033sweatier
sweeper12329373sweeper
sweer84918573swe__er
sweeter103212003sweeter
sweller103012473sweller
swelter103711173swelter
swerver1365733swerver
teared75722153_teared
tearers75218233_tearers
tearier73815613_tearier
teaser65421523_teaser
theater104014253theater
treader84113833treader
treater74219833treater
uneager839753uneager
upbearer1243583upbearer
vealer94016543_vealer
weaker134015443_weaker
weaner93816773_weaner
wearers104615903_wearers
wearier103613293_wearier
weaver123916613_weaver
wreaker143610043wreaker
yarer84321573__yarer
yearner10336873_yearner

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274757.09318895.7
3Display Results4754750.1732745.7
 (SQL Overall)1786914757.67223291.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.