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

138 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
acrogen103819(None) 
acrogens1147241acrogens
acrogenic1447752acrogenic
acrolein1045842acrolein
aerogel836522aerogel
androgen1046312androgen
cryogen1345042_cryogen
kerogen1236082kerogen
pirogen1038262pirogen
pyrogen1337352pyrogen
abdomen1237023abdomen
acerose9310893acerose_
acnode938193acnode_
acnodes1037823acnodes
acorn75616623ac_o_rn
acorned10238263acorned
acrasin9311223acrasin
acre67330773acr__e_
acreage1037833acreage_
acreages1138363acreages
acred87126353acr__ed
acres76327763acr__es
acrider1038623acrider
acrobat11411813acrobat
acrodont1148123acrodont
acrolect1247413acrolect
acroleins1145533acroleins
acromia1139963acromia
acromion1246063acromion
acronic112814693acronic
acronym1445673acronym
across8312643acro_ss
acrotic112515533acrotic
acumen1049013ac_umen
adwomen1345683adwomen
aerobe8412403aerobe_
aerobes9311493aerobes
aerogels945593aerogels
agnomen1036763agnomen
airmen82612353air_men
airwomen1344823airwomen
amidogen1243913amidogen
amylogen1444253amylogen
androgens1145253androgens
anlagen8238633anlagen
antigen8311123antigen
apogean1045443a_pogean
apogee9312553a_pogee
apron7318833apro__n
aproned10311503aproned
argent74023663a_r_gent
argon65520593a_r_gon
arisen65316793a_risen
arose55832083a_rose_
arpen74418043a_r_pen
arrogant949153arrogant
arrowed1148103arrowed
atropin9311583atropin
aurorean844883aurorean
autogeny1245233autogeny
automen939653automen
autopen947123autopen
awoken13457163a_woken
baclofen1543103baclofen
biogen9310253_biogen
brogan9311043_brogan
broken124011523_broken
carageen1155633carageen
careen84119493car_een
cargoes104415223cargoes
carmen104019343car_men
caroled103717683caroled
caroler93816753caroler
caromed123713623caromed
carotene1039133carotene
carotin92216713carotin
carven114716663car_ven
chosen116014133_chosen
cloven114211513_cloven
coden86128543_c_oden
cogent9321003_c_ogent
cogon89120903_c_ogon
copen94826433_c_open
coven106925043_c_oven
cozen165019703_c_ozen
craven114113933_craven
crocein1138073_crocein
crone75231333_crone_
crones84729243_crones
croon75522783_cro_on
crore74922863_crore_
crores86121163_crores
croton84415453_croton
crowed124717293_crowed
crower114117553_crower
crown105620083_cro_wn
croze164719453_croze_
crozer175112843_crozer
crozes174417663_crozes
cryogens1444723_cryogens
cryogeny1743553_cryogeny
dacron94310693dacro__n
endogen938613endogen
estrogen946573estrogen
exogen1436513_exogen
frogmen1335893_frogmen
frozen18408443_frozen
halogen1138393halogen
hydrogen1646283hydrogen
ionogen837123ionogen
kerogens1345763kerogens
kronen10348913_kronen
lysogen1144363lysogen
macron103615673macro__n
mitogen1036963mitogen
morgen9312203mor_gen
naproxen1743203naproxen
nitrogen945823nitrogen
orogeny11107023_orogeny
pathogen1446463pathogen
progeny1389463_progeny
progun968783_progun
proven114314773_proven
pyrogens1437293pyrogens
roger64521413__roger
rouen54920903__rouen
roven85521973__roven
rowen84921153__rowen
screen85216013scr_een
scroggy14243843scroggy
scrooge1037173scrooge_
scrooges1137163scrooges
scrouge1036353scrouge_
scrouged1235373scrouged
scrouges1136683scrouges
trogon73611753_trogon
unroven10238143unroven
zymogen2243693zymogen

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 Limit1340271388.25016245.7
3Display Results1381380.0931483.9
 (SQL Overall)1786911388.49921024.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.