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

153 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
alienees811865(None) 
alienee71013151alienee_
alieners889821alieners
alienages1045972alienages
alienates9310682alienates
aliened81011742alien_ed
aliener71011192alien_er
alienness945372alienness
alienors8136732alienors
aliens65619212alien__s
aligners9117572aligners
alikeness1336332alikeness
aliners74717722ali_ners
alines65735222ali_n_es
aliveness1238222aliveness
alkenes114212752alken_es
saliences11108062saliences
absences1247673absences
absentees1164533absentees
achenes12313493achen_es
acidness1136723acidness
aeneus61111143a__eneus
agenes74720253a_gen_es
ageneses939303a_geneses
agileness1046493agileness
aginners954623aginners
akenes104817343a_ken_es
albedoes1184533albedoes
algidness1144273algidness
aliases7914493ali_ases
alibies9313323ali_bies
alidades1037003alidades
alien56425583alien___
alienage945583alienage
alienate8311553alienate
alienated1047743alienated
aliening91510893aliening
alienism1047733alienism
alienisms1146703alienisms
alienist8411993alienist
alienists946913alienists
alienly1037503alien_ly
aliennesses1145863aliennesses
alienor7116303alien_or
aligned9128553align_ed
aligner8108313align_er
aligns75312953align__s
alikenesses1547193alikenesses
alimented1245313alimented
aliments10311093alimen_ts
alimonies1198333alimonies
aline57243153ali_n_e_
alined75221403ali_n_ed
aliner65621983ali_n_er
alipeds10386793ali_peds
aliunde835003aliunde_
alivenesses1448853alivenesses
alkanes113812933alkan_es
alkanets12366233alkanets
alkene104114003alken_e_
alkines114415733alkin_es
alkynes14336463alkyn_es
allees64521483al__lees
allegers9378233allegers
alleges84212563alle_ges
alleles73812033alle_les
alliances11107093alliances
allonges937313allonges
almners9399563al_mners
almoners1068133almoners
aloneness957313aloneness
alpines94016193alpin_es
alterers82512493alterers
ambiences1545253ambiences
amines84727983ami_n_es
arenes64928393a_ren_es
aridness939223aridness
ariettes8411353ariettes
assignees1043503assignees
attendees1044053attendees
audiences1246003audiences
avenges1157543a_venges
avenses1049643a_venses
avenues1057183a_venues
avidness1246113avidness
azines155517073azi_n_es
blendes104713683bl_endes
blueness1038213blueness
calipees1247413cali_pees
clienteles1252083clienteles
clients938093clien_ts
clines84926043cli_n_es
dienes75719903_dien_es
faiences1337043faiences
falseness1236093falseness
flenses1039473fl_enses
galilees936333gali_lees
glibness1134133glibness
haleness11312623hal_eness
juliennes1642343juliennes
kleenexes2041093kleenexes
lameness102612673lameness
lateness82614073lateness
lenes54738523_l_en_es
lenses64620893_l_enses
levees93714523_l_evees
lianes63819323_lian_es
libelees10227213_libelees
licencees13134643_licencees
licences12129323_licences
licensees1184473_licensees
licenses10118923_licenses
lichees123512783_lichees
lieges74113443_lie_ges
liens56525503_lien__s
liernes739623_liernes
likeness12229863_likeness
limners93311563_limners
linens64818393_li_nens
liners65428853_li_ners
lines57054573_li_n_es
linnets739833_linnets
lioness739103_lioness
listees73416673_listees
liteness82213213_liteness
liveners11217933_liveners
liveness112411393_liveness
maleness10312313mal_eness
maligners12104783maligners
malines93625603mali_n_es
matinees102110423mati_nees
oleines7313393olein_es
paleness10312983pal_eness
patiences1367433patiences
salience10117903salience_
saliencies1246133saliencies
salients839563salien_ts
salines74029413sali_n_es
sapiences13116423sapiences
sciences1238773sciences
signees83510803_signees
silences10310073silences
slieves10378963slie_ves
slimness1036523slimness
trienes74118413trien_es
trientes82812123trientes
valences1388513val_ences
valiances1487203valiances
validness13125363validness
valines104520213vali_n_es
vileness1139983vileness
wieners103212483_wieners
wienies102213683_wienies

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621537.70618967.3
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.93622516.5
 
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.