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 “splats” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
splats8481730(None) 
plats75531371_plats
slats55436901s_lats
spats75031381sp_ats
splat76129341splat_
splays114910871splays
splits85416411splits
sprats85819931sprats
blats75132502_blats
eclats8313032eclats
flats86429742_flats
lats45962702__lats
pats66460852_p_ats
peats76140192_peats
plaits83816472_plaits
plans75731272_plans
plants84921802_plants
plat66048872_plat_
plate74635112_plate
plates85432242_plates
platy105021662_platy
platys11459852_platys
plays106320772_plays
pleats85218592_pleats
plots75025672_plots
prats76333392_prats
salads75316962salads
salals65120082salals
salts55431882sal_ts
scats75930602s_cats
seats54844342s_eats
selahs9313212selahs
shoats94117072shoats
silts55330822sil_ts
skats94621532s_kats
slabs75322642s_labs
slags66525902s_lags
slams74927902s_lams
slants64819082s_lants
slaps76025712s_laps
slat46959022s_lat_
slate55438282s_late
slates64934062s_lates
slaty86523152s_laty
slaws85222712s_laws
slays85723682s_lays
slits56128852s_lits
slots54830522s_lots
sluts54523982s_luts
smalts85214892smalts
solans64122492solans
solate64526072solate
solates73523852solates
spaes76029972sp_aes
spaits85017472spaits
spales84728102spales
spalls84217342spalls
spams94922192sp_ams
spans74528732sp_ans
spars75431542sp_ars
spas67036722sp_a_s
spat66548522sp_at_
spate74731582sp_ate
spates85028172sp_ates
spays105520512sp_ays
speaks125114582speaks
speans85417142speans
spears84019472spears
spelts84614642spelts
spirts85317132spirts
spits74429552sp_its
splake1259782splake
splakes1349672splakes
splash1168822splash
splay105816042spla_y
splents93912132splents
splints94511742splints
split75729012split_
sports84619182sports
spots74424102sp_ots
spouts85115112spouts
sprags95715822sprags
sprat76635972sprat_
sprays115913642sprays
sprits85122532sprits
spurts84814972spurts
squats153712962squats
stats55933362s_tats
stoats65117482stoats
swats85726862s_wats
sweats94814612sweats

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit82551912.70330540.5
3Display Results91910.0303033.3
 (SQL Overall)178691912.85962501.2
 
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.