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

259 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
splatted1135674(None) 
platted103614261_platted
slatted84015181s_latted
spatted104014141sp_atted
splatter10348881splatter
blatted104812712_blatted
flatted114012942_flatted
patted94724682_p_atted
plaited103713892_plaited
planted103516122_planted
plated95225772_pla_ted
platter93917412_platter
plotted104612372_plotted
scatted103512772s_catted
slanted83514742s_lanted
slated75028312s_la_ted
slitted83513312s_litted
slotted84613872s_lotted
solated83618022sola_ted
spathed134013182sp_athed
spatter94016522sp_atter
spitted103912702sp_itted
splashed1435592splashed
splattered13163932splattered
splatters11327542splatters
splayed13357812spla_yed
splinted11369252splinted
splitter10348442splitter
splutter10357442splutter
spotted103713132sp_otted
sprattled1263302sprattled
squatted1835342squatted
swatted114110692s_watted
ablated102513443abla_ted
alated75625143_ala_ted
allotted986873allotted
asphalted1543103asphalted
batted95623653__batted
belated103520013bela_ted
blasted104213473_blasted
blatter94415653_blatter
blotted103911833_blotted
catted95422473__catted
chatted133411893_chatted
clatter94014973_clatter
clotted104011823_clotted
coplotted1444793coplotted
defatted1335673defatted
delated93722873dela_ted
deratted1048403deratted
dilated93115823dila_ted
displanted14126633displanted
dratted9358593_dratted
elated74725823_ela_ted
epilated11310753epila_ted
explanted1944973explanted
fatted105419843__fatted
flatbed13397983_flatbed
flatten10429653_flatten
flatter103815963_flatter
flitted114011643_flitted
gelated93615633gela_ted
glutted937243_glutted
hatted104921513__hatted
implanted1475493implanted
isolated9410523isola_ted
lasted74323603__lasted
lated65240673__la_ted
lathed104718453__lathed
latte55426303__latte_
latten65018203__latten
latter65027893__latter
lattes65324203__lattes
letted74118543__letted
lotted74222403__lotted
matted94521413__matted
misplanted1565443misplanted
opiated1039483opia_ted
panted95024823_p_anted
parted94228683_p_arted
pasted94426903_p_asted
pated85237843_p_a_ted
pattee84323383_p_attee
patten84418193_p_atten
patter84628263_p_atter
petted94121523_p_etted
phatter123810203_phatter
pitted94319593_p_itted
placated1338453_placated
placed114318003_pla_ced
plagued11307473_plagued
plaided11409643_plaided
plained103812233_plained
plaiter93615393_plaiter
planed94420913_pla_ned
planked143512283_planked
planned103810153_planned
planter94017803_planter
plashed133712643_plashed
plaster93318693_plaster
plastid102112523_plastid
plate74635113_pla_te_
platen84518203_pla_ten
plater84427693_pla_ter
plates85432243_pla_tes
platier93716293_platier
platies93722543_platies
platters103415283_platters
played124815033_pla_yed
pleated103816633_pleated
plotter94113663_plotter
plotzed19376213_plotzed
potted94624013_p_otted
prated94924923_pra_ted
prattled11246533_prattled
putted94220253_p_utted
ratted74923343__ratted
related83327573rela_ted
replanted1248063replanted
replated112817513repla_ted
replotted1235823replotted
salaamed1134623salaamed
salaried9311023salaried
salted74121203s__alted
saluted84511703sal_uted
sated66238533s__a_ted
sauted74119603s__auted
scanted104114393s_canted
scarted104816123s_carted
scathed134012643s_cathed
scatter93815173s_catter
sclaffed17102673sclaffed
seated75131053s_ea_ted
sedated93714343seda_ted
selected1159783selected
shafted14288803s_hafted
shatter103615693s_hatter
sheathed1547213sheathed
shitted114212043s_hitted
shotted113912383s_hotted
silted74020013sil__ted
skated114414873s_ka_ted
sklented1335053sklented
slabbed12409503s_labbed
slacked143815453s_lacked
slagged104312763s_lagged
slaked114318273s_la_ked
slammed123511103s_lammed
slanged94112853s_langed
slapped123511843s_lapped
slashed114114853s_lashed
slate55438283s_la_te_
slater64429183s_la_ter
slates64934063s_la_tes
slatey95417063s_la_tey
slather103816063s_lather
slatier74016813s_latier
slattern837093s_lattern
slaved104017043s_la_ved
slayed104716223s_la_yed
sleeted83113223s_leeted
slitter73615873s_litter
slotter73314443s_lotter
smarted105012613s_marted
smatter93613333s_matter
smutted1037463s_mutted
solaced102911063sola_ced
solate64526073sola_te_
solates73523853sola_tes
solvated12237443solvated
sotted74121393s__otted
spaced114517253sp_a_ced
spaded103816753sp_a_ded
spaed85522273sp_a__ed
spalled103113123sp_alled
spammed14348523sp_ammed
spanked143111723sp_anked
spanned104111223sp_anned
spared95427483sp_a_red
sparged113512753sp_arged
sparked143513133sp_arked
sparred104512853sp_arred
spasmed12296993sp_asmed
spate74731583sp_a_te_
spates85028173sp_a_tes
spathe115115693sp_athe_
spathes125116533sp_athes
spattered12187643sp_attered
spatters103914703sp_atters
spawned13316803sp_awned
spayed124213613sp_a_yed
speaned103411523spea_ned
speared104314423spea_red
spectated14236593spectated
spicated13309903spicated
spirited1148963spirited
spirted103913073sp_irted
spited94820443sp__ited
spitter94015183sp_itter
splake1259783spla_ke_
splakes1349673spla_kes
splasher1335653splasher
splashes1337503splashes
splat76129343spla_t__
splats84817303spla_t_s
splatting1235983splatting
spliced124310593spl_iced
splined105013113spl_ined
splinter10329703splinter
splitters11307323splitters
splodged1333263splodged
sploshed1434323sploshed
splotched1742823splotched
splurged1243913splurged
spluttered13153173spluttered
splutters11286263splutters
spluttery14293623spluttery
spoliated1246913spoliated
sported104015433sp_orted
spotter94514873sp_otter
spouted103412263sp_outed
sprained1138433sprained
sprattle1054763sprattle
sprattles1174883sprattles
sprawled1434513sprawled
sprayed13398903spra_yed
sprinted113411163sprinted
spritzed2044783spritzed
sprouted1136383sprouted
spurted103111973sp_urted
sputter94014053sp_utter
squatter1735913squatter
started84217323s_tarted
stated75427833s_ta_ted
statued8459893s_tatued
stetted82610403s_tetted
stotted83511413s_totted
strutted946343strutted
sublated11311493subla_ted
sulcated11310373sulcated
sulfated1238833sulfated
supplanted15113503supplanted
swathed144611933s_wathed
swatter104113323s_watter
sweated113411543swea_ted
swotted11398703s_wotted
tatted74920533__tatted
umlauted1132823umlauted
unhatted1238183unhatted
unletted9310313unletted
unmatted1138293unmatted
unplaited1236883unplaited
unplanted1236853unplanted
updarted1244313updarted
updated11369423upda_ted
uplifted1454423uplifted
uprated103213323upra_ted
upwafted1742193upwafted
vatted104214733__vatted

Search took 9 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.1701051123.5
2DLD Change Limit1461622597.90618487.5
3Display Results2592590.0932784.9
 (SQL Overall)1786912598.16921874.3
 
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.