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

134 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
adrenal83826(None) 
adrenals946301adrenals
adenyl1035022ad_enyl
adnexal1543822adnexal
adrenalin1053462adrenalin
adrenally1344942adrenally
areal55928732a_re_al
arena55323812a_rena_
arenas65021992a_renas
arsenal739382arsenal
renal55929502__renal
acetal84314903a_cetal
achenial1348283achenial
actinal9312293actinal
adagial946363adagial
adaxial1545323adaxial
addend9458453adden_d
addenda10364463addenda
addends10356053addends
adenyls1143923ad_enyls
admen84516183admen__
admiral1046363admiral
adnexa1433673adnexa_
adrenaline1153733adrenaline
adrenalins1153603adrenalins
advent102613753adven_t
advents11309473advents
aerial64625713aer_ial
affinal1336443affinal
agonal7410053a_gonal
agrestal945653agrestal
albinal937813albinal
ammonal1137013ammonal
anal48037523a___nal
anconal939423anconal
anginal8310163anginal
annal56520763a__nnal
anneal64812293anne_al
antennal856353antennal
aortal65217513aor_tal
apneal83411123apne_al
appeal103911613appe_al
apteral9311523apteral
ardency1346483ardency
ardent73022613arden_t
ardently1247453ardently
area45843393a_re_a_
areae55229743a_re_ae
areas55935773a_re_as
areca75618633a_reca_
arecas84817443a_recas
arene55329413a_ren_e
arenes64928393a_renes
areola6813673a_reola
arepa75615563a_repa_
arepas85515703a_repas
argal65023383a_r_gal
argental947933argental
arrayal1055843arrayal
arrear6310253arre_ar
arrival1037563arrival
arsenals847733arsenals
artal55525473a_r_tal
arval86017013a_r_val
asternal858313asternal
atonal6514023a_tonal
atrial65418943atr_ial
aural54428963aur__al
aureola747033aureola
auroral7310473auroral
axonal1347653a_xonal
azonal1568273a_zonal
boreal84817213bore_al
cardinal1139553cardinal
carinal94318223carinal
carnal83919203car_nal
cereal8315833cere_al
corneal94414503corneal
coronal94115763coronal
credal9311673_credal
crenel84213063_crenel
daedal849083_daedal
dareful1157053dareful
daresay1135433daresay
darnel74312183dar_nel
deal56347413_d_e_al
decal85523233_d_ecal
dedal75719023_d_edal
denar65223293_d_enar
denial74720513_d_enial
dental74319173_d_ental
dermal93614343_dermal
dread74419023_dre_ad
dream85120393_dre_am
drear65016903_dre_ar
dreidl835233_dreidl
drench12369593_drench
eternal72910893eternal
frena85915273_frena_
hymenal1545183hymenal
ideal65716393id_e_al
irreal657823irre_al
juvenal1743393juvenal
lienal63912783_lienal
loreal63814313lore_al
lumenal9307273lumenal
madrigal121627253madrigal
madrona10288703madrona_
madronas11288493madronas
maternal1047803maternal
matronal1048113matronal
ordeal779253orde_al
ordinal838633ordinal
parental10310943parental
paternal1038333paternal
patronal1048653patronal
penal75228373__penal
preanal9310713_preanal
prerenal1049083prerenal
real45750293__re_al
regal65023793__regal
regnal74812933__regnal
renail65020763__renail
rental63922023__rental
sternal73411903sternal
tarnal63716503tar_nal
thenal92712413_thenal
trenail7410803_trenail
trinal6516953_trinal
unreal64414453unre_al
ureal56722683_ure_al
urinal6614123_urinal
venal85523213__venal
vernal93514213ver_nal

Search took 8 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 Limit1340271347.03019065.0
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.23224708.4
 
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.