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

68 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
splays11491087(None) 
plays106320771_plays
slays85723681s_lays
spays105520511sp_ays
splats84817301splats
splay105816041splay_
sprays115913641sprays
allays94313742allays
belays114313852belays
byplays1743102byplays
clays105521332_clays
delays104014052delays
displays1446292displays
flays116321052_flays
inlays9389872inlays
lays76043252__lays
misplays1555542misplays
onlays9398712onlays
pays95940222_p_ays
plans75731272_plans
plats75531372_plats
platys11459852_platys
play95928982_play_
playa105812942_playa
playas114612282_playas
ploys105816592_ploys
prays105022432_prays
relays94316752relays
replays12399762replays
salads75316962salads
salals65120082salals
satays94411682satays
says75942102s__ays
selahs9313212selahs
shays116021432s_hays
slabs75322642s_labs
slags66525902s_lags
slams74927902s_lams
slaps76025712s_laps
slats55436902s_lats
slaws85222712s_laws
slay76436382s_lay_
solans64122492solans
spaes76029972sp_aes
spales84728102spales
spalls84217342spalls
spams94922192sp_ams
spans74528732sp_ans
spars75431542sp_ars
spas67036722sp_a_s
spats75031382sp_ats
spay96631662sp_ay_
speaks125114582speaks
speans85417142speans
spears84019472spears
splake1259782splake
splakes1349672splakes
splash1168822splash
splat76129342spla_t
splayed13357812splayed
splits85416412splits
sprags95715822sprags
sprats85819932sprats
spray106720062spray_
stays86022022s_tays
strays96417932strays
sways115518462s_ways
unlays93810492unlays

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 Filter178691825510.343520965.0
2DLD Change Limit82551686.45312792.7
3Display Results68680.0631079.4
 (SQL Overall)178691686.85926052.0
 
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.