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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
sayings11361083(None) 
hayings14379391hayings
mayings134410511mayings
savings114412951savings
saying104325541saying_
agings86312672_agings
askings12519172askings
ayins85321612_ayin_s
bakings144312022bakings
baying125222582baying_
casings104013512casings
cavings134712542cavings
darings93713652darings
dyings11478132_dyings
earings84517712earings
eatings84616442eatings
facings134511262facings
fadings12469302fadings
faying134521072faying_
flyings14496062flyings
frayings15325992frayings
gamings114610912gamings
gatings95212822gatings
gaywings1633192gaywings
haying134420612haying_
hazings20378342hazings
lacings105013652lacings
ladings93814132ladings
lakings124713512lakings
lawings113611472lawings
laying104525702laying_
layins93817652layin_s
lyings10488502_lyings
makings145413162makings
matings104516212matings
maying124421152maying_
pagings114411062pagings
palings103915822palings
parings104219212parings
pavings134011632pavings
paying123722162paying_
racings105015132racings
ratings84217412ratings
ravings114614502ravings
raying105027192raying_
sabines94318482sabines
sabins85521982sabin_s
sackings15389632sackings
sacrings11278922sacrings
sailings93513252sailings
sains55639972sa_in_s
saints65122422sa_ints
salinas73116092salinas
salines74029412salines
saltings92811252saltings
saning75127642saning_
saplings11269802saplings
sarins63932622sarin_s
sarongs84511802sarongs
sasins64923102sasin_s
satangs8479712satangs
sating74735452sating_
satins64930482satin_s
savines104417632savines
saving104724512saving_
savins93923132savin_s
sawing104323812sawing_
sayids104310972sayi_ds
seatings93614302seatings
seeings84411292seeings
sewings11369172sewings
shadings13327432shadings
shavings15356332shavings
shying134211842shying_
sidings94011462sidings
sings65532702s__ings
sizings17378012sizings
skatings13326992skatings
skiings12295732skiings
skying14399982skying_
slatings94011722slatings
slaying113316842slaying_
slings74618012s_lings
soarings93210392soarings
sorings83817252sorings
spacings13287042spacings
spaeings11276252spaeings
spaying133014622spaying_
springs104415922springs
spying123913252spying_
stagings10378342stagings
staying114017322staying_
stings76220182s_tings
strings84617132strings
stying105414572stying_
stylings12276232stylings
swaying143610642swaying_
swings104714452s_wings
takings124512572takings
waxings18366452waxings
zayins18409712zayin_s

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711012.98336094.9
3Display Results1011010.0333060.6
 (SQL Overall)1786911013.39252680.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.