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 “abacuses” 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
abacuses123576(None) 
abacus10349762abacu__s
abases85720772aba__ses
abatises10311012abatises
abscises1246232abscises
abuses85119102ab__uses
accuses114112192a_ccuses
anacruses1145532anacruses
arcuses94814692a_rcuses
abacas104414723abac__as
abalones1038753abalones
abase76023483aba__se_
abased96514993aba__sed
abaser86414343aba__ser
abasers95311973aba__sers
abashes12510373aba_shes
abates85825033aba__tes
abattises1155083abattises
abbacies1445483abbac_ies
abbesses1235333abbesses
abduces1286243ab_duces
abioses9311493ab_ioses
abjures1636523ab_jures
abortuses1144993abortuses
abscess1133903absces_s
abscesses1344103abscesses
abscise1145953abscise_
abscised1364133abscised
abuse77119563ab__use_
abused95614273ab__used
abuser85413683ab__user
abusers94710553ab__users
abysses1234863ab_ysses
accuse103411033a_ccuse_
accused12368423a_ccused
accuser11347933a_ccuser
accusers12285903a_ccusers
acutes83917723__acutes
agaroses938823agaroses
airbuses1067073airbuses
albacores1343323albacores
amasses93912853ama_sses
amuses85117943__amuses
anabases1038083anabases
anaclises1147863anaclises
anacrusis1143893anacrusis
analyses11149963analyses
anatases839793anatases
animuses1037983animuses
ankuses1148203a_nkuses
anuses66218773__anuses
apaches143411843apac_hes
arbutuses1143723arbutuses
arguses84711743a_rguses
arouses74921293a_rouses
asceses938623a_sceses
baases85218013_ba_ases
baches135426943_bac_hes
backset15314193_backset
backsets1638853_backsets
balases93815433_balases
bascules1236683bascules
bases75644353_ba__ses
basses85428303_ba_sses
becurses1236723_becurses
bemuses1139293_bemuses
blouses94014463_blouses
boluses94113833_boluses
bonuses94212953_bonuses
bouses84931783_b_ouses
buses75936013_b__uses
cactuses1237933_cactuses
caucuses1236783caucuses
causes88026473_ca_uses
cayuses12188403_cayuses
circuses1238253circuses
clauses93813323cla_uses
crocuses1239023crocuses
cuscuses1235863cuscuses
discuses113112863discuses
evacuees1382483evacuees
excuses1638903_excuses
favuses1336183_favuses
ficuses12159203_ficuses
flatuses1137173flatuses
focuses12159653_focuses
fracases1336993fracases
fucuses12158353_fucuses
glacises1138513glacises
graduses1046453graduses
hiatuses1135773hiatuses
hocuses121710423_hocuses
incuses93514853_incuses
lacunes9159623_lacunes
macules114015133_macules
meatuses1038203meatuses
mucuses11148513_mucuses
obscures1245513obscures
pauses84621473_pa_uses
reaccuses1345693reaccuses
recuses94619463_recuses
shamuses1336153shamuses
statuses8409543statuses
subcauses1346213subcauses
taluses7311213_taluses
uraeuses835383uraeuses
varuses10310623_varuses
wamuses1237023_wamuses

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.420425454.8
2DLD Change Limit1461621087.11020557.2
3Display Results1081080.0502160.0
 (SQL Overall)1786911087.58023574.0
 
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.