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

187 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
acetous941036(None) 
acerous9513331acerous
acajous1666482acajous
acetals93411352acetals
acetins9313172acetins
acetone9310792acetone
acetones10310032acetones
acetose938842acetose
acetum1038462acet_um
acetyls12285352acetyls
acinous9310932acinous
acoelous1047022acoelous
actors81016762ac_tors
arenous7314182arenous
cerous85821202_cerous
facetious1464442facetious
lacteous1046772lacteous
racemous1246952racemous
setous64917372_setous
abators94413083abators
abets75621673abet__s
abettors1056133abettors
acajou1595233acajou_
acanthous1444423acanthous
acanthus1343353acanthus
acarpous1245313acarpous
acarus8312193ac_arus
acaulous1045923acaulous
accentors13116043accentors
acceptors15114783acceptors
acedias1039773acedias
acerola947823acerola
acerolas1048053acerolas
acerose9310893acerose
aces67645093ace___s
aceta74017353acet__a
acetal84314903acet_al
acetate92514753acetate
acetates102013063acetates
acetic10314503acet_ic
acetify1545003acetify
acetin8314693acet_in
acetonic1238733acetonic
acetoxyl2041763acetoxyl
acetoxyls2151913acetoxyls
acetyl11396553acet_yl
acinus8311253ac_inus
across8312643ac_ross
actins86321103ac_tins
actions94218513actions
actor71116073ac_to_r
acts66929863ac_t__s
aculeus937513aculeus
acutes83917723acut_es
adipous1037183adipous
aeneous739893aeneous
aeneus61111143a_eneus
aeons57624653a_e_ons
agamous1037943agamous
alehouse1146123alehouse
altos55822953a_lto_s
amadous1038503amadous
amatols938183amatols
amorous9311133amorous
ancestors1147233ancestors
anestrous946603anestrous
anestrus856313anestrus
anethols1145843anethols
anserous8410543anserous
anurous7311553anurous
anxious1437283anxious
apercus1136573apercus
apetalous1144583apetalous
aphthous1694873aphthous
apodous1037403apodous
apterous10410463apterous
aqueous1636053aqueous
araceous1049183arace_ous
arduous837613arduous
aretes64425353aret_es
arethusa1142503arethusa
argentous1045603argentous
arsenous847533arsenous
asbestous1143153asbestous
ascetics1247073ascetics
atoms76817563a__toms
aurous64119263a_urous
autobus996513a_utobus
autos56523323a_uto_s
awmous1157713a_wmous
azygous2043123azygous
betons84919553_betons
cachous14312583cachous
cactus104912233cact_us
caestus947773caestus
callous93516603callous
cancerous1367533cancerous
canthus1248713canthus
cantons95221203cantons
cantors94620753cantors
cantos84826973canto_s
cantus85117763cant_us
captious122810573captious
captors113914983captors
carious93320283carious
cartons94122473cartons
caseous9312513caseous
castors94919443castors
cautious103110233cautious
celoms10412123_celoms
census84310303_census
centos85920463_cento_s
cercus105013153_cercus
cereus85215523_cereus
ceros74726073_cero_s
cestos84718093_cesto_s
cestus84412913_cestus
cetes75731103_cet_es
citrous93112993_citrous
citrus83610923_citrus
comous10816503_comous
covetous1347093covetous
cutout8315923_cutout
cutouts938033_cutouts
cymous1388403_cymous
cytons111710183_cytons
detour778193_detour
detours858043_detours
duteous838453duteous
ecotour944363ecotour
ecotours1044463ecotours
facets116316653facet__s
factious13239243factious
factors12912123fac_tors
fetors91014473_fetors
fetus85816543_fet_us
foetors1039763foetors
foetus958523foet_us
gaseous839503gase_ous
hectors123513263hectors
icehouse1344763icehouse
icterus936073icterus
ictus7249703ic_t_us
jetons134512613_jetons
ketols104210763_ketols
larcenous1145013larcenous
lectors93415763lectors
luteous739273luteous
manitous1039173manitous
meous76120063_me_ous
metols84115773_metols
nacreous1045763nacreous
netops839213_netops
ocellus935983ocellus
ocelots977233ocelots
ocherous1347013ocherous
ochrous1237943ochrous
octopus1144813oc_topus
onerous7312973onerous
paletots1047803paletots
petrous92714423_petrous
piceous11310693pice_ous
pistous92714383pistous
piteous9310683piteous
poaceous1267173poace_ous
pretors9316803pretors
ravenous1146793ravenous
rectors93520513rectors
rectos85718783recto_s
rectus83314633rect_us
rhetors1038513rhetors
riotous739863riotous
sacatons1038973sacatons
sclerous1047913sclerous
sectors93116443sectors
serous65023563_serous
setons64620173_setons
setout64719463_setout
setouts74110333_setouts
ulcerous1046163ulcerous
uveous936603uve_ous
vacuous1237023vac_uous
vectors123212593vectors
venous93713193_venous
vetoes92914083_vetoes
wamefous1643763wamefous
zacatons1945703zacatons

Search took 9 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 Limit1340271878.51615738.3
3Display Results1871870.0762460.5
 (SQL Overall)1786911878.74820426.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.