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

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
naysays134412(None) 
naysay1234971naysay_
anyways1644422anyways
assays977902_assays
maydays1634492maydays
nasals63312462na_sals
naysaid1145312naysaid
naysayer1442582naysayer
naysayers1542352naysayers
paydays1634432paydays
waylays1634672waylays
allays94313743_allays
always12409133_always
anyway1534803anyway_
arrays95311683_arrays
assais6711963_assais
assay8710283_assay_
ayahs116813523_ay_ahs
balsams11579013balsams
balsas86417523balsa_s
byways1734673_byways
caesars9410733caesars
casas75327843ca_sa_s
causals91411183causals
causeys12387223causeys
caymans14349513caymans
daystars1243903daystars
essays965653_essays
flyways19133853flyways
gainsays1243513gainsays
gamays126310913ga_mays
gayals1039513gay_als
gaydars1235803gaydars
hansas94616043hansa_s
hearsays1444513hearsays
heydays1734143heydays
kayaks1236333kay_aks
keyways2043373keyways
layaways1743403layaways
margays1337493margays
masas75630413ma_sa_s
massas85116463massa_s
matsahs1236563matsahs
mayas105924383may_a_s
mayday1535883mayday_
missays124010253missays
naans55815253na__ans
nachas114914193nacha_s
nadas66320813na_da_s
naiads739013na_iads
nairas6312783naira_s
nakfas1334683nakfa_s
nalas55528363na_la_s
nanas55928633na_na_s
napas75924353na_pa_s
nappas105511613nappa_s
narwals1036983narwals
nasal56217593na_sa_l
nasty85717283na_sty_
nauseas735993nauseas
navars92810573na_vars
nawabs1185063na_wabs
nays75931593n___ays
naysaying1642983naysaying
naysayings1751493naysayings
nongays11176533nongays
noways12127733n_oways
nyalas936903nyala_s
outsays102710403outsays
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
parlays123910453parlays
payday1536613payday_
playdays1742973playdays
rayahs12579193ray_ahs
rayas85922053ray_a_s
resays93714153_resays
salsas65316133salsa_s
sansars73313913sansars
sarsars73512143sarsars
sashays1336333sashays
satays94411683sa_tays
says75942103___says
skyways2043223skyways
tarsals72512603tarsals
unsays9399543_unsays
vassals1057953vassals
warsaws1335763warsaws
waylay1535453waylay_
yays105728913__y_ays

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit134027916.44020811.6
3Display Results91910.0303033.3
 (SQL Overall)178691916.87325999.0
 
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.