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

205 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
cactuses123793(None) 
accuses114112192_accuses
cactus104912232cactu__s
caestuses1144892caestuses
calluses1039322calluses
campuses1437772campuses
captures1239442captures
carouses10614502carouses
caucuses1236782caucuses
causes88026472ca__uses
cayuses12188402ca_yuses
cestuses1038082cestuses
cistuses1038282cistuses
coituses1039622coituses
contuses10413452contuses
cultuses1037752cultuses
factures13129022factures
ictuses938302_ictuses
lactases1038512lactases
lactoses1039812lactoses
rictuses1037562rictuses
abacuses1235763abac_uses
abuses85119103_a_buses
acanthuses1552643acanthuses
accesses1287493accesses
accrues1135323accru_es
accuse103411033_accuse_
accused12368423_accused
accuser11347933_accuser
accusers12285903_accusers
actives12311523_actives
actress948533_actress
actuates10310313_actuates
acutes83917723_ac_utes
amuses85117943_a_muses
anacruses1145523anacruses
ankuses1148203_ankuses
anuses66218773_a_nuses
arcuses94814693_arcuses
arguses84711743_arguses
arouses74921293_arouses
attunes737823_attunes
baptises1238923baptises
battues94610193battu_es
cabooses1237863cabooses
caches137926913cac__hes
caciques21165373caciques
cackles153717203cac_kles
caddises12329353caddises
caiques18248793caiqu_es
calctufas1641683calctufas
calctuffs1951393calctuffs
calculuses1443193calculuses
calloses10313393calloses
callouses1147683callouses
callused1135853callused
calques182710193calqu_es
camases114216343ca_mases
camasses12388973camasses
camises114218463ca_mises
campused1535253campused
cangues10611823cangu_es
cantles94721413cant_les
cantus85117763cantu__s
canvases13349513canvases
capiases1239253capiases
capsules1236623capsules
captives1538623captives
capture1138913capture_
captured1336573captured
capturer1246093capturer
capturers1344633capturers
carcases12313083carcases
carcasses1337473carcasses
caresses10314063caresses
caritases1139743caritases
caroluses1157613caroluses
carouse9614423carouse_
caroused1149253caroused
carousel1057313carousel
carousels1165343carousels
carouser1068843carouser
carousers1156733carousers
carses85233653ca__rses
cartages11313313cartages
cartes86239473cart__es
caseases10410473caseases
caseoses1039293caseoses
cases75048383ca___ses
casques18278983casqu_es
cassises103811743cassises
castes85631863cast__es
castles94917733cast_les
catches144320773ca_tches
cates75951893ca_t__es
cathouses1439433cathouses
catsups1135343ca_tsups
catties94023053ca_tties
caucused1344093caucused
caucusses1343043caucusses
caules85927253ca__ules
cause75225353ca__use_
caused95117043ca__used
causer84117783ca__user
causers94014793ca__users
causey113513273ca__usey
causeys12387223ca__useys
cayuse11207763ca_yuse_
censuses10187543censuses
centeses1079443centeses
cereuses1049243cereuses
ceruses93716233c_eruses
chanteuses1543803chanteuses
chastises1437703chastises
chiauses1336483chiauses
choruses1339983choruses
chouses125117813c_houses
cinctures1346063cinctures
circuses1238253circuses
citruses1037483citruses
clauses93813323c_lauses
clonuses1057133clonuses
clotures10299023clotures
coleuses1039723coleuses
confuses13310363confuses
contuse9311413contuse_
contused1138443contused
cornuses10310033cornuses
corpuses12310063corpuses
costumes1258013costumes
coutures10311993coutures
crocuses1239023crocuses
cruses88127713__cruses
cultures10310153cultures
cuscuses1235863cuscuses
cutises94414913c_utises
cycases1437533cyc_ases
cyclases1537133cyclases
cycloses1538183cycloses
cypruses1534313cypruses
ductules1155543ductules
ectases92911673_ectases
excuses1638903exc_uses
facture12108923facture_
favuses1336183fa_vuses
fetuses10310243_fetuses
ficuses12159203fic_uses
flatuses1137173flatuses
focuses12159653foc_uses
foetuses1136083foetuses
fractures14147233fractures
fucuses12158353fuc_uses
galluses936963galluses
hachures1645873hachures
halituses1245573halituses
hiatuses1135773hiatuses
hocuses121710423hoc_uses
iambuses1235783iambuses
incuses93514853inc_uses
jacobuses2042713jacobuses
lactase937953lactase_
lactates10311223lactates
lactones10311223lactones
lactose969473lactose_
lacunes9159623lac_unes
lectures101310153lectures
lotuses74011253_lotuses
macules114015133mac_ules
maltases1039693maltases
maltoses1039853maltoses
mantises10317923mantises
matures9314303ma_tures
meatuses1038203meatuses
mucuses11148513muc_uses
natures7311963na_tures
noctules1036583noctules
passuses1036773passuses
pastises103616053pastises
pastures10311963pastures
pauses84621473pa__uses
pectases122411193pectases
pictures1249343pictures
practises1349623practises
rachises131412413rachises
radiuses937043radiuses
raptures1037573raptures
reaccuses1345693reaccuses
recluses105111733recluses
recuses94619463rec_uses
ruckuses1444913ruckuses
saccules1237033saccules
sacques18106863sacqu_es
scouses93313243_scouses
situses72710493_situses
statuses8409543statuses
tactless10288463tactless
taluses7311213ta_luses
tartufes1164153tartufes
valguses1234233valguses
varuses10310623va_ruses
waftures1434853waftures
walruses11554973walruses
wammuses1543493wammuses
wampuses1534113wampuses
wamuses1237023wa_muses

Search took 10 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 Limit1461622058.95316325.5
3Display Results2052050.0932204.3
 (SQL Overall)1786912059.46618877.1
 
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.