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

165 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
cactoid1231103(None) 
factoid1338691factoid
cacti9318642cact_i_
cancroid1346522cancroid
carotid102014832carotid
cestoid104011672cestoid
coccoid11299282coccoid
cycloid1539282cycloid
cystoid13309212cystoid
factoids1446242factoids
mastoid10711232mastoid
mattoid1079282mattoid
acanthoid1553933acanthoid
acarid95017073_acarid
acaroid103512313acaroid
accord1178843_accord
acid77533393_ac__id
acold86214923_ac_old
acrid86920103_ac_rid
acted88521733_act_ed
actin74922553_act_in
actinoid1148013_actinoid
action84719683_action
actor71116073_acto_r
actors81016763_actors
agatoid948623agatoid
algoid83011473_algoid
anthoid11313313_anthoid
aroid65428343_a_roid
autoed7712823_autoed
avoid95516683_a_void
bacteroid1456253bacteroid
cacao95420003cacao__
cacaos104616183cacao_s
cached145419203cac_hed
cachou13310623cacho_u
cachous14312583cachous
cackled164613293cackled
cactus104912233cact_us
caid77837533ca___id
camelid1249413camelid
cameoed1238383cameoed
cancroids1444533cancroids
candid104517853ca_ndid
canid85526343ca__nid
canoed94618953ca_noed
canted94825783cant_ed
canthi11310973canthi_
cantic103920543cant_ic
canto74931013canto__
canton85722993canto_n
cantoned111411523cantoned
cantons95221203cantons
cantor85621523canto_r
cantors94620753cantors
cantos84826973canto_s
cantrip112910043cantrip
capsid11312413ca_psid
captain112111063captain
caption113513693caption
captor104914603capto_r
captors113914983captors
carabid12311333carabid
carcinoid1465663carcinoid
cardioid1247443cardioid
carload1039783carload
carotids11229943carotids
carotin92216733carotin
carted98631443cart_ed
cartload1145033cartload
carton84522663carto_n
cartoned111312833cartoned
cartons94122473cartons
cartoon94114463cartoon
cartop104213563carto_p
castled104311513castled
castoff1547793castoff
castor84418533casto_r
castors94919443castors
catbird1235243ca_tbird
catenoid1149113catenoid
cation83925503ca_tion
catkin123512383ca_tkin
catlin83819083ca_tlin
catnip1097973ca_tnip
cattail939183cattail
catted95422473ca_tted
cattie85221023ca_ttie
caution93013523caution
ceboid11310653c_eboid
centroid1159313centroid
ceratoid1149923ceratoid
cestoi84511953cestoi_
cestoids11308273cestoids
chancroid1743993chancroid
cheloid13310833cheloid
choroid13311803choroid
chytrid1645733chytrid
cichlid1545313cichlid
cirsoid1038123cirsoid
cissoid1037343cissoid
coacted123611613coact_ed
coaction12310773coaction
coactor1139123coacto_r
coactors1239473coactors
coccid102910743coc_cid
coccoids12176793coccoids
colloid10312883colloid
conchoid1688043conchoid
conoid9818883c_onoid
coracoid1348153corac_oid
cormoid12310403cormoid
cricoid1239243cricoid
crinoid1039943crinoid
ctenoid1078683ctenoid
cuboid1139503c_uboid
cuckold1643723cuckold
cycloids1647043cycloids
cymoid1459473c_ymoid
cystoids14306733cystoids
dacoit9415453dac_oit
deltoid938573deltoid
dentoid9310663dentoid
faction122613333faction
factoidal1543333factoidal
factor11911453facto_r
factored1436213factored
factors12912123factors
factory15108343factory
fantod102010033fanto_d
fucoid1237893fuc_oid
gadoid9310463ga_doid
ganoid8314443ga_noid
haemoid1337203haemoid
haloid104317763ha_loid
haploid1339833haploid
histoid1139823histoid
labroid1038823labroid
lactic10713493lact_ic
lactone9311393lactone
lactonic1248043lactonic
lactose969473lactose
lentoid8310683lentoid
manatoid1148823manatoid
mantid93820383mant_id
mastoids1177873mastoids
mattoids1196183mattoids
mucoid1139783muc_oid
naevoid1194593naevoid
noctuid1064383noctuid
noctuoid1163503noctuoid
paction112713963paction
parotid102915513parotid
parotoid11410033parotoid
patois84319363pa_tois
phytoid1678753phytoid
placoid1239773plac_oid
racemoid1344813racemoid
sarcoid10310453sarcoid
sautoir735183sautoir
scaphoid1646053scaphoid
tabloid1048263tabloid
tactic10612753tact_ic
taction93213023taction
valgoid1255213valgoid

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271656.61020276.4
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.82926166.5
 
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.