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

99 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
araceous104918(None) 
apiaceous1344052apiaceous
arenaceous1253632arenaceous
ceraceous1346352ceraceous
fabaceous1643072fabaceous
gracious1138592gracious
poaceous1267172poaceous
racemous1246952_racemous
abacus10349763abac__us
acajous1666483aca_jous
acarpous1245313acarpous
acaulous1045923acaulous
acerous9513333__acerous
acetous9410363__acetous
aeneous739893a_eneous
agamous1037943aga_mous
alliaceous1252593alliaceous
amadous1038503ama_dous
aqueous1636053a_queous
arabesks1442743arabesks
arames84622573arame__s
araneids947743araneids
arboreous1144293arboreous
arborous1047723arborous
archons12311583ar_chons
arcus76918863ar_c__us
arduous837613ar_duous
arenous7314183ar_enous
arquebus1942263arquebus
arsenous847533arsenous
arsonous846393arsonous
atrocious1146043atrocious
audacious1244673audacious
braceros12397723braceros
bracers114616703brace_rs
braces108427773brace__s
cachous14312583_cachous
capacious1546603capacious
caracols12310413carac_ols
carcajous20134743carcajous
caseous9312513_caseous
cetaceous1344943cetaceous
coriaceous1444263coriaceous
crankous1435973crankous
curvaceous1752583curvaceous
dracenas1145793dracenas
drupaceous1551933drupaceous
edacious1146023edacious
ericaceous1453183ericaceous
farinaceous1661923farinaceous
frabjous2042633frabjous
fractious1456143fractious
fractus12146593frac_tus
gaseous839503_gaseous
graceful1445393graceful
graces94523493grace__s
griseous945613griseous
herbaceous1753023herbaceous
lacteous1046773_lacteous
larcenous1145013lar_cenous
marabous1249063mara_bous
micaceous1544223micaceous
nacreous1045763_nacreous
parachors1647403parachors
piceous11310693_piceous
pinaceous1345323pinaceous
pomaceous1544473pomaceous
precious12310593precious
predaceous1553943predaceous
racemes1139093_racemes
racers84725433_race_rs
races74943243_race__s
racons84319343_rac_ons
racoons93912433_racoons
ramous8417113_ra_mous
rapacious1345243rapacious
raucous938303_raucous
ravenous1146793_ravenous
rosaceous1144243rosaceous
sagacious1244673sagacious
salacious1147103salacious
sarcous9312933sar_c_ous
sebaceous1343913sebaceous
sericeous1146343sericeous
setaceous1145323setaceous
spacious1237813spacious
tracers94917843trace_rs
traces85329933trace__s
tractors10312563tractors
trappous1246023trappous
tufaceous1442863tufaceous
turacous1047143turac_ous
uraeus638793ura_e_us
uranous7310733ura_nous
vacuous1237023_vacuous
varactors1446393varactors
veracious1447123veracious
vinaceous1444173vinaceous
voracious1445503voracious

Search took 8 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 Limit146162997.39019778.3
3Display Results99990.0462152.2
 (SQL Overall)178691997.84222786.4
 
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.