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

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

108 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
saccades1313725(None) 
saccade12107031saccade_
accedes1237712_accedes
alcades101011472_alcades
arcades101113192_arcades
cascades13128552cascades
facades1339032fa_cades
saccadic1244172saccadic
saccate111311762saccate_
saccules1237032saccules
scalades11258802scalades
soccages1336382soccages
abrades10312073_abrades
accede1138293_accede_
acceded1336093_acceded
acceder1235353_acceder
acceders1334793_acceders
accidies1338033_accidies
accolades1445423_accolades
accrues1135323_accrues
accuses114112193_accuses
acnodes1037823_acnodes
alcade91111513_alcade_
alcaides11117673_alcaides
alcaldes11114983_alcaldes
alcaydes14133723_alcaydes
arcade91013643_arcade_
arcaded1178973_arcaded
ashcakes1753733ashcakes
aubades1038743_aubades
baccae12119703bacca_e_
baccaras1446913baccaras
baccate131011263baccate_
baccated15148373baccated
ballades114211643ballades
brocades1358703brocades
cades85440733___cades
carcases12313083carcases
cascade12118603cascade_
cascaded14135703cascaded
clades94920463__clades
cockades1738433cockades
daycares1454803daycares
decades113615513_decades
escalades1244403escalades
escapades1442993escapades
facade1238803fa_cade_
gambades1435863gambades
jacales16310323ja_cales
lactases1038513lactases
lactates10311223lactates
macrames1438953macrames
maenades1137473maenades
naiades838213na_iades
oatcakes1445543oatcakes
packages17138733packages
pancakes1637073pancakes
parades104121463pa_rades
parkades1538273parkades
passades1139203passades
rachides141511223rachides
reaccedes1454463reaccedes
saccharides1953753saccharides
saccule1136743saccule_
sacculus1244813sacculus
sacques18106863sa_cques
sacrals93311793sacra_ls
sades65239893s___ades
saices84221803saic__es
salads75316963sa_lad_s
salvages1238123salvages
sarapes94617743sa_rapes
sarcasms1244983sarcasms
sarodes84216143sa_rodes
satiates8314633satiates
sauces84919503sauc__es
sausages937003sausages
savages1139973sa_vages
savates10312953sa_vates
scads85419953s__cad_s
scalade10359263scalade_
scalados11276083scalados
scalages113010253scalages
scalares103210983scalares
scales84529313s__cales
scapes105122263s__capes
scares85033003s__cares
scrapes116217663s_crapes
seascapes1344813seascapes
secedes103711983s_ecedes
secludes1134953secludes
secondes1138133secondes
shades105924533s__hades
socages101012053s_ocages
soccage1236283soccage_
spades94222583s__pades
staccatos1343723staccatos
stades74626243s__tades
stoccados1442533stoccados
stockades1644433stockades
subcodes1338133subcodes
succahs1435323succa_hs
succeeds1343693succeeds
sucrases10310253sucrases
suicides1139083suicides
tacnodes1144993tacnodes
vacates12312833va_cates
vaccines1536503vaccines

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621087.86018595.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.06222164.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.