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

93 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
splay10581604(None) 
play95928981_play
slay76436381s_lay
spay96631661sp_ay
splat76129341splat
splays114910871splays
spray106720061spray
allay85620392allay
belay105021522belay
byplay1634192byplay
clay95927412_clay
delay94820632delay
display1336662display
flay106332802_flay
inlay85214322inlay
lay68865352__lay
misplay1436382misplay
onlay84212942onlay
paly95835532_paly
pay88461182_p_ay
plan65833942_plan
plat66048872_plat
platy105021662_platy
playa105812942_playa
plays106320772_plays
ploy96123602_ploy
ply86323552_pl_y
pray96331532_pray
relay84424672relay
replay113412922replay
salad65321832salad
salal55425702salal
salary9515212salary
sally85129712sally
salty85524382salty
satay84718462satay
say67264762s__ay
scaly104718722scaly
selah8319612selah
shaly114322862shaly
shay107133342s_hay
silky125315822silky
silly84527612silly
silty84721632silty
slab67133762s_lab
slag55934352s_lag
slam67737972s_lam
slap66434042s_lap
slat46959022s_lat
slaty86523152s_laty
slaw77930712s_law
slays85723682s_lays
sly66228562s_l_y
sola45541862sola_
solan55328152solan
solar55927342solar
spa55730812sp_a_
spacy125415622spacy
spae65034322sp_ae
spale74929212spale
spall74919302spall
spam85930042sp_am
span65234662sp_an
spar65433302sp_ar
spas67036722sp_as
spat66548522sp_at
spays105520512sp_ays
spaz155626162sp_az
speak114618672speak
spean74620512spean
spear75821062spear
spicy125417712spicy
spiky146014112spiky
spiny104921302spiny
spiry105017352spiry
splake1259782splake
splash1168822splash
splashy1543552splashy
splats84817302splats
splayed13357812splayed
split75729012split
sprag86418692sprag
sprat76635972sprat
sprays115913642sprays
spry96819122sp_ry
spumy124610362spumy
spy86023742sp__y
stay78333722s_tay
stray88525572stray
sulky124715362sulky
sully84622892sully
sway107128232s_way
unlay84613702unlay

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800931.48336277.8
3Display Results93930.0303100.0
 (SQL Overall)178691931.606111264.6
 
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.