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

181 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
alienee7101315(None) 
aliened81011741aliened
alienees8118651alienees
aliener71011191aliener
alien56425582alien__
alienage945582alienage
alienate8311552alienate
alieners889822alieners
alienly1037502alienly
alienor7116302alienor
aliens65619212alien_s
aligned9128552aligned
aligner8108312aligner
aline57243152ali_n_e
alined75221402ali_ned
aliner65621982ali_ner
alines65735222ali_nes
aliunde835002aliunde
alkene104114002alken_e
alkenes114212752alkenes
salience10117902salience
absence1137713absence
absentee1067663absentee
achene11313813achen_e
achenes12313493achenes
agene65621583a_gen_e
agenes74720253a_genes
aginner844663aginner
akene95818663a_ken_e
akenes104817343a_kenes
alane56135613al_an_e
alee46652323al___ee
aliases7914493aliases
alibied1038143alibied
alibies9313323alibies
alible8311973ali_ble
alidade936993alidade
alienable1146933alienable
alienages1045973alienages
alienated1047743alienated
alienates9310683alienates
aliening91510893aliening
alienism1047733alienism
alienist8411993alienist
alienness945373alienness
alienors8136733alienors
align65016503align__
aligners9117573aligners
aligns75312953align_s
alike95523963ali__ke
alikeness1336333alikeness
aliment9316703alimen_t
alimented1245313alimented
aliments10311093aliments
aliners74717723aliners
aliped95414283ali_ped
alive85722513ali__ve
aliveness1238223aliveness
alkane104313323alkan_e
alkanes113812933alkanes
alkanet113714433alkanet
alkine104916803alkin_e
alkines114415733alkines
alkyne13436863alkyn_e
alkynes14336463alkynes
allee54932123al__lee
allees64521483alle_es
allege74314653alle_ge
alleged9389323alleged
alleger8319633alleger
alleges84212573alleges
allele64514563alle_le
alleles73812033alleles
alliance1097263alliance
allonge837023allonge
almner85710723al_mner
almoner949383almoner
alone55732963al_on_e
alpine84417373alpin_e
alpines94016193alpines
altered83215733altered
alterer72713993alterer
alumnae955403alumnae
alvine94614583alvin_e
ambience1455353ambience
amine75835383ami_n_e
amines84727983ami_nes
apiece10510083apie_ce
arene55329413a_ren_e
arenes64928393a_renes
ariette7312373ariette
assignee944843assignee
attendee946403attendee
audience1146583audience
avenge1087553a_venge
avenue957953a_venue
azine146721413azi_n_e
azines155517073azi_nes
blende95413443bl_ende
calipee11412913cali_pee
client8316343clien_t
clientele1142533clientele
clients938093clients
cline76428533cli_n_e
clines84926043cli_nes
diene65720133_dien_e
dienes75719903_dienes
faience1237513faience
flense938903fl_ense
galilee8312213gali_lee
jinnee13411573_jinnee
julienne1542223julienne
kleenex1842383kleenex
ladened979053ladened
latened8711923latened
lenes54738523_l_enes
lense54523433_l_ense
levee84023813_l_evee
liane54720663_lian_e
lianes63819323_lianes
libelee92510983_libelee
licence11119363_licence
licencee12116463_licencee
license9148423_license
licensee10166303_licensee
licente91210893_licente
lichee114017973_lichee
lieder74912323_lieder
liefer9529573_liefer
liege65314433_lie_ge
lieges74113443_lieges
lien45339803_lien__
lienal63912783_lienal
liens56525503_lien_s
lierne638023_lierne
liernes739623_liernes
lieve86315473_lie_ve
liever94611863_liever
likened12267353_likened
limned94811473_limned
limner84112873_limner
line46965573_li_n_e
lined64934643_li_ned
linen55728723_li_nen
liner55938923_li_ner
lines57054573_li_nes
liney87029633_li_ney
linnet6419423_linnet
lisente71210703_lisente
listee64223063_listee
livened11238933_livened
livener10278943_livener
maligned1285773maligned
maligner11115333maligner
maline84529083mali_n_e
malines93625603mali_nes
matinee92415613mati_nee
oleine6313793olein_e
oleines7313393oleines
patience1247523patience
saliences11108063saliences
saliency13125393saliency
salient7419763salien_t
salients839563salients
saline65132703sali_n_e
salines74029413sali_nes
sapience12106613sapience
science1138783science
signee73617233_signee
silence9310213silence
slieve9359273slie_ve
slieves10378963slieves
soignee8279133soignee
triene64316383trien_e
trienes74118413trienes
valence1268773val_ence
valiance1397383valiance
valine94623093vali_n_e
valines104520213vali_nes
wiener94513543_wiener
wienie9229973_wienie

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.406440125.6
2DLD Change Limit1340271816.33021173.3
3Display Results1811810.0603016.7
 (SQL Overall)1786911816.79626293.6
 
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.