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

127 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
kerogen123608(None) 
kerogens1345761kerogens
acrogen1038192acrogen
aerogel836522aerogel
exogen1436512_exogen
kerosene1254822kerosene
kronen10348912k_ronen
pirogen1038262pirogen
pyrogen1337352pyrogen
acrogens1147243acrogens
aerobe8412403aerobe_
aerobes9311493aerobes
aerogels945593aerogels
androgen1046313androgen
berobed1238233berobed
berouged1235323berouged
betoken13386503betoken
biogen9310253_biogen
brogan9311043_brogan
broken124011523_broken
cerumen1147763cerumen
cryogen1345043cryogen
endogen938613endogen
erode64520993_erode_
eroded84313583_eroded
erodent8313823_erodent
erodes74819883_erodes
erogenic111110543_erogenic
erose55727273_erose_
eroses65327053_eroses
estrogen946573estrogen
exogens1536883_exogens
frogmen1335893_frogmen
frozen18408443_frozen
germen9612313ger_men
halogen1138393halogen
herdmen13238453herdmen
heroes94923823hero_es
heroin94420593hero_in
heroine103517483heroine
heron85025503hero__n
hydrogen1646283hydrogen
ionogen837123ionogen
kedge115513693ke_dge_
kedged13439713ke_dged
kedges124812943ke_dges
keen84830403ke___en
kegged13469243ke_gged
kegger12388063ke_gger
keppen14346563ke_ppen
keratin113314153keratin
kerbed13339693ker_bed
kerfed14358223ker_fed
kermes124616123ker_mes
kern85326213ker___n
kerne94718213ker_ne_
kerned114112923ker_ned
kernel104010583ker_nel
kernes104717523ker_nes
kerosenes1345453kerosenes
kerosine1238143kerosine
kerries113317913kerries
kersey1336783ker_sey
kerygma1741963kerygma
ketogenic1645793ketogenic
ketone105014533ketone_
ketones115014503ketones
ketose105711813ketose_
ketoses114912873ketoses
kirkmen1232923kirkmen
kraken955883k_raken
krone94018733k_rone_
kroner104612573k_roner
kroon94514483k_ro_on
kurgan11126783kur_gan
lysogen1144363lysogen
merge84523683mer_ge_
merged104214943mer_ged
mergee94018133mer_gee
merger95016473mer_ger
merges94122483mer_ges
mermen10813813mer_men
mitogen1036963mitogen
morgen9312203mor_gen
neogene847553ne_ogene
nitrogen945823nitrogen
oestrogen1044443oestrogen
orogeny11107023_orogeny
perigean1146353perigean
perigee101113383perigee
perigon1039853perigon
petrogeny1544973petrogeny
progeny1389463_progeny
progun968783_progun
proven114314773_proven
pyrogens1437293pyrogens
refrozen2063873refrozen
reopen8311573re_open
rerisen73613643rerisen
rerose63320843rerose_
rewoken145112293rewoken
rewoven13557933rewoven
roger64521413__roger
rouen54920903__rouen
roven85521973__roven
rowen84921153__rowen
serge64727463ser_ge_
serged84118763ser_ged
serger73819733ser_ger
serges74225963ser_ges
teratogen1044183teratogen
terreen7257573terreen
trogon73611753_trogon
unroven10238143unroven
verboten1344313verboten
verge93419833ver_ge_
verged114815153ver_ged
verger104315693ver_ger
verges104320173ver_ges
xenogeny1943443xenogeny
xeroses143612823xeroses
xeroxed14244513xeroxed
xeroxes13246443xeroxes
yeomen1138183ye_omen
zeroed16409413zero_ed
zeroes154314343zero_es
zymogen2243693zymogen

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.1401276364.3
2DLD Change Limit1340271276.12621878.4
3Display Results1271270.0304233.3
 (SQL Overall)1786911276.29628381.7
 
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.