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

269 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
splatter1034888(None) 
platter93917411_platter
spatter94016521sp_atter
splatted11356741splatted
splatters11327541splatters
splitter10348441splitter
splutter10357441splutter
blatter94415652_blatter
clatter94014972_clatter
flatter103815962_flatter
latter65027892__latter
patter84628262_p_atter
phatter123810202_phatter
plaiter93615392_plaiter
planter94017802_planter
plaster93318692_plaster
plater84427692_pla_ter
platier93716292_platier
platted103614262_platted
platters103415282_platters
plotter94113662_plotter
scatter93815172s_catter
shatter103615702s_hatter
slater64429182s_la_ter
slather103816072s_lather
slatier74016812s_latier
slatted84015182s_latted
slattern837092s_lattern
slitter73615872s_litter
slotter73314452s_lotter
smatter93613332s_matter
spatted104014142sp_atted
spatters103914702sp_atters
spitter94015182sp_itter
splasher1335662splasher
splattered13163932splattered
splinter10329702splinter
splitters11307322splitters
splutters11286272splutters
spluttery14293622spluttery
spotter94514882sp_otter
sputter94014052sp_utter
squatter1735912squatter
swatter104113322s_watter
aflutter1163813aflutter
aglitter935093aglitter
allotter866473allotter
batter84928873__batter
bespatter1343143besp_atter
betatter1035453betatter
blaster94017303_blaster
blather125314203_blather
blatted104812713_blatted
blatters104414093_blatters
blotter94612853_blotter
chatter124416643_chatter
clatters103313913_clatters
clattery13378193_clattery
clutter94211663_clutter
dilater83515653dila_ter
elater64724203_ela_ter
fatter94523213__fatter
flatted114012943_flatted
flatten10429653_flatten
flatters113814203_flatters
flattery14338293_flattery
flitter103413903_flitter
flutter104012093_flutter
glitter84211803_glitter
hatter94724873__hatter
implanter1385363implanter
laster64830633__laster
later54843923__la_ter
lather95124353__lather
latte55426303__latte_
latten65018203__latten
lattes65324203__lattes
letter63722583__letter
litter64324853__litter
lotter64025603__lotter
matter84325343__matter
natter64420743__natter
palter84423263_p_alter
paster85734373_p_aster
pater74740723_p_a_ter
patted94724683_p_atted
pattee84323383_p_attee
patten84418193_p_atten
pattern93712053_p_attern
patters94825193_p_atters
patzer173111643_p_atzer
pearter9412743_pearter
peatier94017233_peatier
petter83924773_p_etter
piaster93012883_piaster
pilaster1038163pilaster
placater1238013_placater
placer105117743_pla_cer
plaguer10328273_plaguer
plainer93811983_plainer
plaister1068013_plaister
plaited103713893_plaited
plaiters103512633_plaiters
planer84122653_pla_ner
plankter1435363_plankter
planner93511623_planner
plantar9369993_plantar
planted103516123_planted
planters102915323_planters
plasher124215033_plasher
plasters103518133_plasters
plastery13279703_plastery
plate74635113_pla_te_
plated95225773_pla_ted
platen84518203_pla_ten
platers93924093_pla_ters
plates85432243_pla_tes
platies93722543_platies
player115215213_pla_yer
pleater93916333_pleater
pleather1356653_pleather
plotted104612373_plotted
plotters104011553_plotters
plottier10327263_plottier
potter83926983_p_otter
prater84825353_pra_ter
prattler10166343_prattler
psalter9247813_psalter
putter83921443_p_utter
ratter64326313__ratter
relater73723143rela_ter
reletter81311023reletter
replaster1136583replaster
salter64325083s__alter
saltier74318633sal_tier
saluter73512453sal_uter
scanter94215183s_canter
scatted103512773s_catted
scatters103612753s_catters
scattier10267583s_cattier
sclaffer16112653sclaffer
scutter93512173s_cutter
seater64534163s_ea_ter
sedater83713633seda_ter
seltzer1635213sel_tzer
setter64023723s__etter
shatters113313913s_hatters
sheather1458233sheather
shutter103712143s_hutter
silenter838873silenter
siltier73413863sil_tier
sitter63323383s__itter
skater105015493s_ka_ter
skitter113810403s_kitter
slabber113311393s_labber
slacker133915293s_lacker
slaker104219273s_la_ker
slammer113913033s_lammer
slander84015443s_lander
slanted83514743s_lanted
slapper113512463s_lapper
slasher104515333s_lasher
slate55438283s_la_te_
slated75028313s_la_ted
slaters73123733s_la_ters
slates64934063s_la_tes
slatey95417063s_la_tey
slathers113914783s_lathers
slatterns935363s_latterns
slaver94419613s_la_ver
slayer93916333s_la_yer
slither104112983s_lither
slitted83513313s_litted
slitters84014133s_litters
slittier837003s_littier
slotted84613883s_lotted
slotters84012403s_lotters
sluttier836453s_luttier
smarter94113133s_marter
smatters104011713s_matters
solacer93011103sola_cer
solander948123solander
solate64526073sola_te_
solated83618023sola_ted
solates73523853sola_tes
spacer104917793sp_a_cer
spacier114011633sp_acier
spader94317133sp_a_der
spaller92713473sp_aller
spammer133410433sp_ammer
spanker133612353sp_anker
spanner94312563sp_anner
sparer84524963sp_a_rer
sparger103613083sp_arger
sparker133914363sp_arker
sparser94311483sp_arser
spate74731583sp_a_te_
spates85028173sp_a_tes
spathe115115693sp_athe_
spathed134013183sp_athed
spathes125116533sp_athes
spattered12187643sp_attered
spawner12347363sp_awner
speaker133311213spea_ker
spearer93913663spea_rer
specter113111733sp_ecter
spelter94113703sp_elter
spinster1036683spinster
spitted103912703sp_itted
spitters104113383sp_itters
splake1259783spla_ke_
splakes1349673spla_kes
splashed1435593splashed
splashers1445283splashers
splashes1337503splashes
splashier1443593splashier
splat76129343spla_t__
splats84817303spla_t_s
splattering1454543splattering
splatting1235983splatting
splayed13357813spla_yed
splicer114710523spl_icer
splinted11369253splinted
splinters11277923splinters
splintery14264793splintery
splurger1143813splurger
spluttered13153173spluttered
splutterer12132743splutterer
sporter93616553sp_orter
sportier102010053sportier
spotted103713143sp_otted
spotters104313383sp_otters
spottier10207313spottier
spouter94213223sp_outer
sprattle1054763sprattle
sprattled1263313sprattled
sprattles1174883sprattles
sprawler1334653sprawler
sprayer12369043spra_yer
sprinter103810813sprinter
spritzer1944563spritzer
spurter94013003sp_urter
sputters104012873sp_utters
sputtery13366473sp_uttery
spymaster1642583spymaster
squatted1835343squatted
squatters1834943squatters
squattier1843713squattier
starter73817883s_tarter
stater64427563s_ta_ter
straiter8311783straiter
strutter846503strutter
stutter72911463s_tutter
supplanter14113673supplanter
swather134213603s_wather
swatted114110693s_watted
swatters113911793s_watters
sweater103712723swea_ter
sweatier1147033sweatier
swotter10399473s_wotter
tatter64024573__tatter
updater10347253upda_ter
upgather14152753upgather
uplander1145533uplander
uplifter1363903uplifter
upsetter1034643upsetter
upstater10156663upstater
watter93221983__watter
yatter94116213__yatter

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.406440125.6
2DLD Change Limit1461622696.48322545.4
3Display Results2692690.0932892.5
 (SQL Overall)1786912696.98225593.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.