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

203 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
splatting123598(None) 
platting114813031_platting
slatting94014231s_latting
spatting113111761sp_atting
splitting1236561splitting
blatting114111652_blatting
flatting123511252_flatting
patting103722342_p_atting
plaiting113113512_plaiting
planting113515382_planting
plating103823072_pla_ting
plotting113011012_plotting
scatting113311812s_catting
slanting94115092s_lanting
slating83724652s_la_ting
slattings10346072s_lattings
slitting93012582s_litting
slotting92612612s_lotting
solating9315592sola_ting
spitting113012322sp_itting
splashing1535702splashing
splattering1454542splattering
splaying14219302spla_ying
splinting1238192splinting
spotting112812092sp_otting
sprattling1363052sprattling
squatting1934512squatting
swatting12309592s_watting
ablating11312003abla_ting
allotting1046503allotting
asphalting1643383asphalting
batting104422273__batting
blasting114013433_blasting
blotting113910433_blotting
catting103922643__catting
chatting142810143_chatting
clotting113110643_clotting
coplotting1555953coplotting
defatting1436103defatting
delating103119603dela_ting
deratting1139513deratting
dilating102714913dila_ting
displanting1546043displanting
dratting10389663_dratting
elating83423083_ela_ting
epilating12310973epila_ting
explanting2045223explanting
fatting113818703__fatting
flatling123410013_flatling
flitting123010883_flitting
gelating103015733gela_ting
glutting10247643_glutting
hatting113920233__hatting
implanting1545323implanting
inletting1087873inletting
isolating1039743isola_ting
lasting84725243__lasting
lathing114315693__lathing
lattin64316223__lattin_
lattins74115483__lattins
letting83218533__letting
lotting82917753__lotting
matting103620143__matting
misplanting1645633misplanting
opiating11410093opia_ting
panting104025423_p_anting
parting103527383_p_arting
pasting103826553_p_asting
petting103720953_p_etting
pitting103618873_p_itting
placating1438513_placating
placing123815283_pla_cing
plaguing1236033_plaguing
plaining113911553_plaining
plaitings12296243_plaitings
planing103418253_pla_ning
planking153513013_planking
planning113610223_planning
plantings12348403_plantings
plashing143311063_plashing
platina94413643_pla_tina
platings113611363_pla_tings
playing133816093_pla_ying
plaything1843853_plaything
pleating112916053_pleating
plotzing20276153_plotzing
potting103720893_p_otting
prating103424453_pra_ting
prattling1246303_prattling
putting103218573_p_utting
ratting83822363__ratting
relating92725443rela_ting
reletting102713943reletting
replanting1338523replanting
replating122217403repla_ting
replotting1357043replotting
resplitting1444943resplitting
salaaming1265363salaaming
salarying1336073salarying
salting84120793s__alting
saluting9310553sal_uting
sating74735453s__a_ting
scanting113914763s_canting
scarting113415263s_carting
scathing14269703s_cathing
sclaffing1843363sclaffing
seating84130683s_ea_ting
sedating103014113seda_ting
selecting12310533selecting
setting83621393s__etting
shafting15278683s_hafting
sheathing1636873sheathing
shitting123212663s_hitting
shotting123012383s_hotting
shutting12309693s_hutting
silting83320483sil__ting
sitting83519633s__itting
skating123613853s_ka_ting
sklenting1475123sklenting
slabbing13287783s_labbing
slacking153914133s_lacking
slagging113711583s_lagging
slaking123717473s_la_king
slamming133310003s_lamming
slanging103413433s_langing
slapping133510843s_lapping
slashing123713413s_lashing
slatings94011723s_la_tings
slaving113514833s_la_ving
slaying113316843s_la_ying
sleeting93114163s_leeting
smarting113212453s_marting
smutting11278063s_mutting
solacing11310133sola_cing
solvating1336443solvating
spacing123614493sp_a_cing
spading113114383sp_a_ding
spaeing103413543sp_a_eing
spalling113213463sp_alling
spamming15317603sp_amming
spanking153911973sp_anking
spanning113311083sp_anning
sparging122611133sp_arging
sparing104823873sp_a_ring
sparking152812543sp_arking
sparling112714533sp_arling
sparring113112223sp_arring
spartina1037983sp_artina
spasming13227203sp_asming
spattering13107793sp_attering
spawning14296913sp_awning
spaying133014623sp_a_ying
speaking153212493spea_king
speaning113512243spea_ning
spearing113216103spea_ring
spectating1546623spectating
spiriting1238413spiriting
spirting112913633sp_irting
spiting103917623sp__iting
splatted11356743splatt_ed
splatter10348883splatt_er
splatters11327543splatters
splicing1338963spl_icing
splining11310773spl_ining
splodging1433303splodging
sploshing1544293sploshing
splotching1842863splotching
splurging1333623splurging
spluttering1463363spluttering
spoliating1366963spoliating
sporting112415463sp_orting
spouting113511953sp_outing
spraining1248153spraining
sprawling15175123sprawling
spraying14299883spra_ying
sprinting12310033sprinting
spritzing2135393spritzing
sprouting1236943sprouting
spurting113111633sp_urting
starting93116173s_tarting
stating83725163s_ta_ting
stetting93410713s_tetting
stotting92811163s_totting
strutting1037003strutting
sublating12310983subla_ting
subletting1346273subletting
sulfating1338063sulfating
supplanting1643923supplanting
swathing15248713s_wathing
sweating123213023swea_ting
swotting12268483s_wotting
tatting84019523__tatting
umlauting1243163umlauting
unhatting1335873unhatting
unplaiting1345503unplaiting
upcasting1434823upcasting
updarting1334333updarting
updating1236593upda_ting
uplifting1534963uplifting
uprating11311113upra_ting
upsetting1275563upsetting
upwafting1842063upwafting
vatting113614853__vatting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412036.73322076.5
3Display Results2032030.0802537.5
 (SQL Overall)1786912037.23624694.7
 
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.