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

382 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
aliener7101119(None) 
aliened81011741aliened
alienee71013151alienee
alieners889821alieners
alienor7116301alienor
aligner8108301aligner
aliner65621981ali_ner
aginner844662aginner
alien56425582alien__
alienees8118652alienees
alienly1037502alienly
alienors8136732alienors
aliens65619212alien_s
aligned9128552aligned
aligners9117562aligners
aline57243152ali_ne_
alined75221402ali_ned
aliners74717722ali_ners
alines65735222ali_nes
alkene104114002alkene_
alkenes114212752alkenes
alleger8319622alleger
almner85710722al_mner
almoner949382almoner
alterer72713992alterer
lieder74912322_lieder
liefer9529572_liefer
liever94611862_liever
limner84112862_limner
liner55938912_li_ner
livener10278932_livener
maligner11115332maligner
wiener94513542_wiener
abider95314463abi_der
absenter1086773absenter
acceder1235353acceder
achene11313813achene_
achenes12313493achenes
achiever1643843achiever
acinar8310483aci_nar
actioner1048663actioner
adherer1137563adherer
adorner8246973adorner
agene65621583a_gene_
agenes74720253a_genes
aginners954623aginners
aglimmer1342343aglimmer
aglitter935093aglitter
aider65431133a_i_der
aimer75926823a_i_mer
airer54927893a_i_rer
airier64619363a_irier
airliner836953airli_ner
aiver85725163a_i_ver
akene95818663a_kene_
akenes104817343a_kenes
alane56135613al_ane_
alder65421913al__der
alee46652323al_e_e_
alegar739283al_egar
alerter72111513alerter
aliases7914493aliases
alibied1038143alibied
alibies9313323alibies
alible8311973alible_
alienage945583alienage
alienages1045973alienages
alienate8311553alienate
alienated1047743alienated
alienates9310683alienates
alienator946193alienator
aliening91510893aliening
alienism1047733alienism
alienist8411993alienist
alienness945373alienness
align65016503align__
aligns75312953align_s
alike95523963ali_ke_
alikeness1336333alikeness
aliment9316703alimen_t
alimented1245313alimented
aliments10311093aliments
aliped95414283ali_ped
aliunde835003aliunde
alive85722513ali_ve_
aliveness1238223aliveness
alkane104313323alkane_
alkanes113812933alkanes
alkanet113714433alkanet
alkine104916803alkine_
alkines114415733alkines
alkyne13436863alkyne_
alkynes14336463alkynes
allayer10148213allayer
allee54932123alle_e_
allees64521483alle_es
allege74314643allege_
alleged9389313alleged
allegers9378233allegers
alleges84212563alleges
allele64514563allele_
alleles73812033alleles
allover1038583allover
allurer7348433allurer
almemar1144303almemar
almners9399563al_mners
almoners1068133almoners
alone55732963al_one_
alpine84417373alpine_
alpines94016193alpines
alter54828503al__ter
altered83215733altered
alterers82512493alterers
altimeter1146613altimeter
alvine94614583alvine_
ambeer104511593ambe_er
ameer75618983a_me_er
amender10349613a_mender
amine75835373ami_ne_
amines84727983ami_nes
ammeter1148393ammeter
ancienter1145393ancienter
apiece10510083apiece_
arene55329413a_rene_
arenes64928393a_renes
arider74717743ari_der
ascender1136733ascender
assenter867703assenter
assigner944853assigner
atoner64817193a_toner
attender935913attender
avenger1135493a_venger
awakener1543433awakener
azine146721413azi_ne_
azines155517073azi_nes
barrener1038333barrener
battener10369393battener
believer13448423believer
biner75930693_bi_ner
bleeder10359643bleeder
bleeper11458253bleeper
blender104613843bl_ender
blinder103912983blinder
blinker134110213blinker
blister94415313blister
blither124812173blither
blitzer18447663blitzer
briefer1235563briefer
briner84519043bri_ner
byliner1235723byli_ner
calender1138273cal_ender
caliber1139733cali_ber
caliper11410963cali_per
careener1039323careener
chiefer1536863chiefer
cleaner93712303cleaner
clever114611533cl_ever
clicker154111883clicker
client8316343clien_t
clients938093clients
climber13449133climber
cline76428533cli_ne_
clines84926043cli_nes
clinger103812143clinger
clinker133811663clinker
clipper133710323clipper
cloner84418093cl_oner
coiner84323783coi_ner
cozener18328953cozener
dampener1335533dampener
darkener1335993darkener
diene65720133_diene_
dienes75719903_dienes
dieter73516773_dieter
diner65632903_di_ner
dinner74217153_dinner
eloigner943423eloigner
eloiner7149183eloiner
enlivener1242653enlivener
evener91010623_evener
fainer94717243fai_ner
falconer1346033falconer
falterer11239853falterer
fastener11227833fastener
fattener11268113fattener
feigner1135593feigner
finer85431563_fi_ner
fleecer12368033fleecer
fleer86020773fl_e_er
fleeter103210363fleeter
flenser1036783fl_enser
flicker163610623flicker
flier86023403fli__er
flinder11319873flinder
flinger113710503flinger
flipper14389143flipper
flirter10318673flirter
flitter103413903flitter
flivver1633043flivver
gainer74117493gai_ner
gardener1037103gardener
ginner73915813_ginner
gleaner8379773gleaner
glibber1235163glibber
glider84614263gli_der
glimmer12437713glimmer
glister84013343glister
glitter84211803glitter
goldener1045403goldener
greener83111713greener
griever1136033griever
grinner8329233grinner
hardener1238883hardener
harkener1537573harkener
hastener11259133hastener
inner54920623__inner
joiner134114133joi_ner
keener104012833_keener
kleenex1842383kleenex
klister113410643klister
labeler92310183labeler
ladened979053ladened
lamenter1038863lamenter
lanner64920593_lanner
larcener1036493larcener
lateener835763lateener
latened8711923latened
laveer94110423lave_er
lavender1235143lavender
leaner64022193_leaner
leer46239353_l_e_er
leger65721503_l_eger
lender73921273_l_ender
lenes54738523_l_enes
leper74820743_l_eper
lever85125163_l_ever
liane54720663_liane_
lianes63819323_lianes
libber104414003_libber
libeler9219003_libeler
liber74723613_li_ber
licencer12146123_licencer
licenser10155873_licenser
licker125222043_licker
liege65314433_liege_
lieges74113443_lieges
lien45339803_lien__
lienal63912783_lienal
liens56525503_lien_s
lientery1134873_lientery
lier45942463_li__er
lierne638023_lierne_
liernes739623_liernes
lieve86315473_lieve_
lifer85822153_li_fer
lifter93814813_lifter
liger65024463_li_ger
likened12267353_likened
liker95627063_li_ker
limber104316773_limber
limier83518713_limier
limmer104314793_limmer
limned94811473_limned
limners93311553_limners
limper104117853_limper
line46965573_li_ne_
linear65113333_linear
lined64934643_li_ned
linen55728723_li_nen
liners65428843_li_ners
lines57054573_li_nes
liney87029623_li_ney
linger75225993_linger
linier64423783_linier
linker104321463_linker
linnet6419413_linnet
linter64625333_linter
lipper104219633_lipper
lisper84114433_lisper
listener8158303_listener
lister64527253_lister
liter54736343_li_ter
lither94520953_lither
litter64324853_litter
livened11238933_livened
liveners11217923_liveners
liver85132963_li_ver
livier97514593_livier
livyer12426293_livyer
loaner64416503_loaner
loner55431033_l_oner
maligned1285773maligned
maligners12104783maligners
maline84529083mali_ne_
malines93625603mali_nes
malinger11116533malinger
mariner93315993mari_ner
miner76933543_mi_ner
oftener1035923oftener
oleine6313793oleine_
oleines7313393oleines
opener83910993_opener
orienter838313orienter
palier85023563pali__er
palterer102411273palterer
parcener1238463parcener
patienter1145553patienter
piecer105213083_piecer
pilsener1044753pilsener
pilsner935343pilsner
pinner84521493_pinner
plainer93811983plainer
planer84122653pl_aner
planner93511623planner
plier75221283pli__er
plinker134010963plinker
preener93114833preener
quieter162810333quieter
rattener8238533rattener
ravener104110733ravener
reliever11448683reliever
riever94811653_riever
ripener937903ripener
ruiner64013643rui_ner
salience10117893salience
saliences11108063saliences
saliency13125393saliency
salient7419763salien_t
salients839563salients
salimeter1157373salimeter
saline65132703sali_ne_
salines74029413sali_nes
seiner64622483sei_ner
serener73415753serener
shiner93820873shi_ner
signer74015623_signer
silencer1036293silencer
silenter838873silenter
sinner64320593_sinner
skinner11348093skinner
sleeker11339823sleeker
sleeper93211563sleeper
slender83413593sl_ender
slicer84117603sli_cer
slickener1544043slickener
slicker133314533slicker
slider73918363sli_der
slier54827243sli__er
slieve9359273slieve_
slieves10378963slieves
slimier93212013slimier
slimmer114211343slimmer
slinger83413823slinger
slipper113712973slipper
slither104112983slither
slitter73615873slitter
sliver94116593sli_ver
sliverer11237633sliverer
spieler93111233spieler
spinner93912263spinner
sullener857243sullener
tailender1044073tailender
teener64717503_teener
thinner10358963thinner
tinner64119953_tinner
triene64316383triene_
trienes74118413trienes
tweener10306833tweener
twiner94012593twi_ner
vainer93714573vai_ner
valine94623093vali_ne_
valines104520213vali_nes
veiner94514753vei_ner
viewer1237213_viewer
wakener1446913wakener
warrener1136913warrener
weiner94214133wei_ner
whiner124516633whi_ner
whitener1435733whitener
widener11318693widener
wieners103212483_wieners
winner94219923_winner

Search took 10 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 Limit1340273828.70315400.1
3Display Results3823820.1732208.1
 (SQL Overall)1786913829.03219784.2
 
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.