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

130 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
saccade1210703(None) 
saccades13137241saccades
saccate111311761saccate
accede1138292_accede
alcade91111512_alcade
arcade91013642_arcade
baccae12119702bacca_e
baccate131011262baccate
cascade12118602cascade
facade1238802fa_cade
saccadic1244172saccadic
saccule1136742saccule
scalade10359262scalade
soccage1236282soccage
abrade9313053_abrade
acceded1336093_acceded
acceder1235353_acceder
accedes1237713_accedes
accidie1247733_accidie
accolade1346043_accolade
accrue1035823_accrue
accuse103411033_accuse
acnode938193_acnode
acuate8315633_acuate
alcades101011473_alcades
alcaide1088453_alcaide
alcalde10104953_alcalde
alcayde13103723_alcayde
arcaded1178973_arcaded
arcades101113193_arcades
arcane81216743_arcane
ashcake1663373ashcake
aubade939223_aubade
bacca111012183bacca__
baccara1347143baccara
baccated15148373baccated
ballade104012563ballade
brocade1238533brocade
cade76443913___cade
carcase11312733carcase
cascaded14135703cascaded
cascades13128553cascades
clade85821013__clade
cockade1638133cockade
daycare1355093daycare
decade104216163_decade
escalade1144383escalade
escapade1343303escapade
facades1339033fa_cades
faciae112913413facia_e
falcate12311613falcate
gambade1336383gambade
lactase937953lactase
lactate9312693lactate
macchie1647193macchie
macrame1338713macrame
manmade1237963manmade
oatcake1345363oatcake
package16128013package
pancake1536673pancake
parade94720643pa_rade
parkade1437583parkade
passade1039233passade
reaccede1354363reaccede
saccharide1853633saccharide
sacculate1349023sacculate
saccules1237033saccules
sacculi1145043sacculi
sacked135525213sacked_
saclike131210123saclike
sacque17107113sa_cque
sacra74516993sacra__
sacral83414413sacra_l
sacrals93311793sacrals
sacred94917103sacred_
sade55544473s___ade
saice75424053saic__e
salad65321833sa_lad_
salads75316963sa_lads
salpae84614273salpa_e
salvage1138193salvage
sambaed1238303sambaed
sarape84817573sa_rape
sarcasm1136693sarcasm
sarode75317513sa_rode
satiate7315403satiate
sauce75121653sauc__e
sauced93913303sauced_
saunaed836703saunaed
sausage847193sausage
savage10410173sa_vage
savate9313783sa_vate
scad75725763s__cad_
scads85419953s__cads
scalades11258803scalades
scalado10276473scalado
scalage103110533scalage
scalare93311833scalare
scale74629143s__cale
scape96921843s__cape
scare75334463s__care
scrape105917573s_crape
seascape1245173seascape
secede93311993s_ecede
seclude1035233seclude
seconde1037413seconde
shade95125583s__hade
siccan1037593sicca_n
sicced11489653sicced_
socage91012123s_ocage
soccages1336383soccages
spade84423323s__pade
spicae104313703spica_e
spicate113214193spicate
staccati1244673staccati
staccato1244063staccato
stade64825303s__tade
stoccado1342953stoccado
stockade1544523stockade
subcode1237163subcode
succah1336643succa_h
succahs1435323succahs
succeed1235983succeed
sucrase9310343sucrase
suicide1038893suicide
sulcate9314423sulcate
tacnode1045083tacnode
toccate1138773toccate
vacate11314553va_cate
vaccine1437323vaccine

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.1561145455.1
2DLD Change Limit1340271306.39020974.5
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.59227107.3
 
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.