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

319 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
alieners88982(None) 
alienees8118651alienees
aliener71011191aliener_
alienors8136731alienors
aligners9117571aligners
aliners74717721ali_ners
aginners954622aginners
aliened81011742aliene_d
alienee71013152aliene_e
alienness945372alienness
alienor7116302alienor_
aliens65619212alien__s
aligner8108312aligner_
alikeness1336332alikeness
aliner65621982ali_ner_
alines65735222ali_ne_s
aliveness1238222aliveness
alkenes114212752alkene_s
allegers9378232allegers
almners9399562al_mners
almoners1068132almoners
alterers82512492alterers
limners93311562_limners
liners65428852_li_ners
liveners11217932_liveners
maligners12104782maligners
wieners103212482_wieners
abiders104011083abi_ders
absenters1156173absenters
acceders1334793acceders
achenes12313493achene_s
achievers1743433achievers
acidness1136723acidness
actioners1147723actioners
adherers1296923adherers
adorners9196623adorners
aeneus61111143a__eneus
agenes74720253a_gene_s
agileness1046493agileness
aginner844663aginner_
aiders74524633a_i_ders
aimers84621913a_i_mers
airers64922313a_i_rers
airliners945983airli_ners
aivers94822323a_i_vers
akenes104817343a_kene_s
alders74218423al__ders
alegars838933al_egars
algidness1144273algidness
aliases7914493aliase_s
alibies9313323alibie_s
alien56425583alien___
alienage945583alienage
alienages1045973alienages
alienate8311553alienate
alienates9310683alienates
alienators1045783alienators
aliening91510893aliening
alienism1047733alienism
alienisms1146703alienisms
alienist8411993alienist
alienists946913alienists
alienly1037503alien_ly
aligned9128553aligne_d
aligns75312953align__s
aliments10311093alimen_ts
aline57243153ali_ne__
alined75221403ali_ne_d
alipeds10386793ali_peds
alkanes113812933alkane_s
alkanets12366233alkanets
alkene104114003alkene__
alkines114415733alkine_s
alkynes14336463alkyne_s
allayers11156633allayers
allees64521483alle_e_s
alleger8319633alleger_
alleges84212573allege_s
alleles73812033allele_s
allovers1137673allovers
allurers8286773allurers
almemars1243523almemars
almner85710723al_mner_
almoner949383almoner_
aloneness957313aloneness
alpines94016193alpine_s
alterer72714003alterer_
alters64924223al__ters
altimeters1246353altimeters
ambeers11428923ambe_ers
ameers84015573a_me_ers
amenders11288353a_menders
amines84727983ami_ne_s
ammeters1237693ammeters
arenes64928393a_rene_s
aridness939223aridness
ascenders1235683ascenders
assenters966993assenters
assigners1044413assigners
atoners75013953a_toners
attenders1045273attenders
avengers1235583a_vengers
avidness1246113avidness
awakeners1643093awakeners
azines155517073azi_ne_s
batteners11238163batteners
believers14346633believers
biners85023633_bi_ners
bleeders11448453bleeders
bleepers12377493bleepers
blenders115210993bl_enders
blinders113911143blinders
blinkers14388503blinkers
blisters104015083blisters
blithers134711233blithers
blitzers19417153blitzers
blueness1038213blueness
briefers1335143briefers
briners94315633bri_ners
byliners1334753byli_ners
calenders1237403cal_enders
calibers1238523cali_bers
calipers1249443cali_pers
careeners1138543careeners
cleaners103610543cleaners
clickers163910203clickers
clients938093clien_ts
climbers14318413climbers
clines84926043cli_ne_s
clingers113810663clingers
clinkers14339833clinkers
clippers14368843clippers
clivers123411753cli_vers
cloners94514823cl_oners
coiners93620753coi_ners
cozeners19297783cozeners
dampeners1444663dampeners
darkeners1435153darkeners
dienes75719903_diene_s
dieters83216433_dieters
diners75525953_di_ners
dinners83915443_dinners
eloigners1042993eloigners
eloiners8128153eloiners
enliveners1342683enliveners
eveners10109503_eveners
falconers1445323falconers
falseness1236093falseness
falterers12238033falterers
fasteners12237053fasteners
fatteners12236873fatteners
feigners1235483feigners
fleecers13325933fleecers
fleers96015793fl_e_ers
flensers1135463fl_ensers
flickers17338883flickers
fliers94417193fli__ers
flinders12439263flinders
flingers123410193flingers
flippers15338003flippers
flirters11337933flirters
flitters114312173flitters
flivvers1733113flivvers
gainers84214593gai_ners
gardeners1136603gardeners
ginners84314223_ginners
gleaners9348073gleaners
glibness1134133glibness
gliders94811843gli_ders
glimmers13396153glimmers
glisters93912603glisters
glitters93710543glitters
grievers1255473grievers
grinners9288043grinners
haleness11312623hal_eness
hardeners1338083hardeners
harkeners1636073harkeners
hasteners12267813hasteners
inners63919353__inners
joiners144211573joi_ners
keeners113610783_keeners
klisters123910483klisters
labelers10249413labelers
lameness102612673lameness
lamenters1137683lamenters
lanners73618333_lanners
larceners1135993larceners
lateeners945563lateeners
lateness82614073lateness
laveers10329363lave_ers
lavenders1334753lavenders
leaners73718173_leaners
leers54828983_l_e_ers
legers74518313_l_egers
lenders84419643_l_enders
lenes54738523_l_ene_s
lepers84817323_l_epers
levers94621323_l_evers
lianes63819323_liane_s
libbers113812833_libbers
libelers10238623_libelers
libers84721443_li_bers
licencers13134643_licencers
licensers11114583_licensers
lickers134118253_lickers
lieder74912323_lieder_
liefer9529573_liefer_
lieges74113443_liege_s
liens56525503_lien__s
lientery1134883_lientery
liernes739623_lierne_s
liers55130403_li__ers
liever94611863_liever_
lifers95617843_li_fers
lifters104313783_lifters
ligers75022043_li_gers
likeness12229863_likeness
likers104620913_li_kers
limbers113614743_limbers
limmers113413083_limmers
limner84112873_limner_
limpers113815223_limpers
linens64818393_li_nens
liner55938923_li_ner_
lines57054573_li_ne_s
lingers84223303_lingers
linkers114317713_linkers
linnets739833_linnets
linters73822633_linters
lioness739103_lioness
lippers113416443_lippers
lispers94514323_lispers
listeners9147323_listeners
listers74026533_listers
liteness82213213_liteness
liters65429883_li_ters
litters73422573_litters
livener10278943_livener_
liveness112411393_liveness
livers94927823_li_vers
liviers104211073_liviers
livyers13365903_livyers
loaners73913623_loaners
loners64225813_l_oners
maleness10312313mal_eness
maligner11115333maligner_
malines93625603mali_ne_s
malingers1285853malingers
mariners103113863mari_ners
miners84126633_mi_ners
oleines7313393oleine_s
openers9339493_openers
orienters937613orienters
paleness10312983pal_eness
palterers11249533palterers
parceners1337453parceners
piecers114112253_piecers
pilseners1144943pilseners
pilsners1035533pilsners
pinners93518603_pinners
planers94517943pl_aners
planners10399933planners
pliers84715153pli__ers
plinkers14309393plinkers
preeners102712813preeners
quieters17248733quieters
ratteners9237263ratteners
raveners11309133raveners
relievers12387063relievers
rievers104311453_rievers
ripeners1036833ripeners
ruiners74213023rui_ners
saliences11108063saliences
salients839563salien_ts
salimeters1256523salimeters
salines74029413sali_ne_s
seiners74219273sei_ners
shiners104015943shi_ners
signers84714443_signers
silencers1145283silencers
sinners74019023_sinners
skinners12347293skinners
sleekers12377993sleekers
sleepers103110113sleepers
slicers94114923sli_cers
slickeners1643663slickeners
slickers143112553slickers
sliders83515223sli_ders
slieves10378963slieve_s
slimmers12369633slimmers
slimness1036523slimness
slingers93712683slingers
slippers123711233slippers
slithers114212953slithers
slitters84014133slitters
sliverers12196363sliverers
slivers104115253sli_vers
spielers10319653spielers
spinners103810863spinners
tailenders1143643tailenders
teeners74415453_teeners
thinners11327753thinners
tinners73717313_tinners
trienes74118413triene_s
tweeners11306243tweeners
twiners10459633twi_ners
validness13125363validness
valines104520213vali_ne_s
veiners104112523vei_ners
viewers1337173_viewers
vileness1139983vileness
wakeners1535843wakeners
warreners1236193warreners
weiners103913063wei_ners
whiners134011573whi_ners
whiteners1535243whiteners
wideners12257993wideners
wiener94513543_wiener_
winners104316913_winners

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.406440125.6
2DLD Change Limit1461623197.21620255.3
3Display Results3193190.1262531.7
 (SQL Overall)1786913197.74823062.9
 
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.