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

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
spacious123781(None) 
specious1247481specious
capacious1546602capacious
edacious1146022edacious
gracious1138592gracious
rapacious1345242rapacious
sagacious1244672sagacious
salacious1147102salacious
sanious7514102s_anious
scabious1246592scabious
scarious10610202scarious
spacings13287042spacings
spaciously1746402spaciously
spurious1036962spurious
acinous9310933__acinous
acinus8311253__acinus
apiaceous1344053apiaceous
araceous1049183araceous
audacious1244673audacious
auspicious1453493auspicious
bodacious1443993bodacious
cachous14312583_cachous
captious122810573captious
carious93320283_carious
diecious1146873diecious
factious13239243_factious
fractious1456143fractious
fugacious1543613fugacious
luscious1044853luscious
minacious1346183minacious
pactions122613503_pactions
pappous1057463_pappous
parlous9414293_parlous
parous84024163_pa_rous
patios85221783_patio_s
paviors1237603_paviors
paviour1244623_paviour
paviours1343613_paviours
piceous11310693_piceous
pious74621273_p__ious
poaceous1267173poaceous
precious12310593precious
sajous13310583s_a_jous
sapajous1744833sapajous
saporous1039053saporous
sarcous9312933s_arcous
saviors1058993s_aviors
saviour1035213s_aviour
saviours1154273s_aviours
scabrous1245993scabrous
scions82612243s__cions
sebaceous1343913sebaceous
sepalous1047523sepa_lous
sequacious2152653sequacious
serious73616283s_erious
setaceous1145323setaceous
shackoes17367853shackoes
shackos16429023shacko_s
silicious1146433silicious
simious939803s_imious
spacers113813873spac_ers
spaces104722633spac__es
spacial1138763spaci_al
spacier114011633spaci_er
spaciest122310893spaciest
spaciness1337083spaciness
spacing123614493spaci_ng
spackles16319953spackles
spadices1336093spadices
spadixes1834113spadixes
spaeings11276253spaeings
spahis11310383spahi__s
spails84817823spa_i_ls
spaits85017473spa_i_ts
spambots1443313spambots
spaniels1045963spaniels
sparids103512123spari_ds
sparoids11218713sparoids
sparrows1344803sparrows
spavies123012943spavi_es
spavins12419323spavi_ns
specials1238033specials
species11314133speci_es
speciously1746343speciously
spermous1247933spermous
sphagnous1542813sphagnous
spinous9310443sp_inous
spiritous1155023spiritous
spumous1135853sp_umous
stannous846443stannous
stations82415223stations
studious9245553studious
suasions838783suasions
suspicious1453963suspicious
tenacious1146423tenacious
vacuous1237023_vacuous
various103113103_various
veracious1447123veracious
vicious1239493_vicious
vivacious1743923vivacious
voracious1445503voracious

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.406440125.6
2DLD Change Limit1461621017.84318636.0
3Display Results1011010.0303366.7
 (SQL Overall)1786911018.27921583.6
 
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.