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

129 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
accusers1228590(None) 
accuser11347931accuser_
accuses114112191accuse_s
abusers94710552a_busers
acceders1334792acceders
accouters1344862accouters
accusals12145052accusals
accuse103411032accuse__
accused12368422accuse_d
amusers94610192a_musers
arcuses94814692arcuse_s
arousers84810982arousers
causers94014792_causers
excusers1734442excusers
focusers13134372focusers
abacuses1235763abacuse_s
abasers95311973a_basers
abjurers1733943abjurers
abuser85413683a_buser_
abuses85119103a_buse_s
acceder1235363acceder_
accedes1237723accede_s
accepters15114603accepters
access1037683acc__ess
accesses1287493accesses
accorders14144123accorders
accosts11107993accos_ts
accouter1245363accouter_
accoutres1344383accoutres
accrues1135323accrue_s
accursed1354633accurse_d
accurst1146243accu__rst
accusal11136003accus_al
accusant1246863accusant
accusants1344283accusants
accusing1336783accusing
accustom1443663accustom
accustoms1543343accustoms
acquests1944643acquests
acquirers2043413acquirers
acquires1945403acquires
aculeus937513a_culeus
acumens1136953a_cumens
acuter84412863a_cuter_
acutes83917723a_cute_s
adducers1283443adducers
adjurers1634373adjurers
adjusters1744163adjusters
advisers12135003advisers
allurers8286773allurers
amassers10337843amassers
ambushers1643433ambushers
amuser84712623a_muser_
amuses85117943a_muse_s
ankuses1148203ankuse_s
anuses66218773a_nuse_s
apposers1236283apposers
archers124414573arc_hers
arguers8489033argu_ers
arguses84711743arguse_s
arouser74514423arouser_
arouses74921293arouse_s
asceses938623ascese_s
assumers1064963assumers
assurers866313assurers
augers73818703a__ugers
augurers9114813augurers
cacklers163710703cacklers
cactuses1237933cactuse_s
carousers1156743carousers
caucuses1236783caucuse_s
causer84117783_causer_
causes88026473_cause_s
causeys12387223_causeys
cayuses12188403cayuse_s
censers94313903_censers
chasers123714923_chasers
chousers134610203chousers
closers94415323_closers
clusters102912403_clusters
coursers104412303_coursers
couters93827303_couters
cruisers10438283_cruisers
cruses88127713_cruse_s
crusets93811043_crusets
crushers134010093_crushers
cubers105318353__cubers
curers84923193__curers
cursers94317163_cursers
cusecs10509153__cusecs
cussers94213403_cussers
defusers12487363defusers
dousers84817273_dousers
excuser1635813excuser_
excuses1638903excuse_s
ficuses12159203ficuse_s
focuser12155783focuser_
focuses12159653focuse_s
fucuses12158353fucuse_s
grousers93810733grousers
hocuses121710433hocuse_s
housers104717823_housers
ictuses938303ictuse_s
incuses93514853incuse_s
infusers11286143infusers
lacquers19125033lacqu_ers
misusers10348083misusers
mousers95216443_mousers
mucuses11148513mucuse_s
musers84719103__musers
nonusers8268003nonusers
occulters1343453occulters
occupiers1542273occupiers
occurs10136553occu__rs
pausers94113223_pausers
perusers10328803perusers
reaccuses1345693reaccuse_s
recuses94619463recuse_s
refusers11499273refusers
rousers75220143_rousers
saccules1237033saccule_s
scaupers12378173scaupers
schussers1442553schussers
scourers10348533scourers
scouses93313243scouse_s
scouters103411323scouters
securers1057153securers
trousers83910633trousers
users55817573___users

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.533335255.2
2DLD Change Limit1461621296.70321805.5
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.28224538.7
 
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.