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

170 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
aliyah1239749(None) 
aliya83713481aliya_
aliyahs13395321aliyahs
aliyas93911801aliyas
alias55834602ali_as
alidad838882alidad
aliyos9349532aliyos
aliyot93611712aliyot
almah106917252al_mah
ayah108022992a__yah
aah616252963a___ah
abaya104413173abaya_
abayas114011703abayas
acinar8310483acinar
agita6315423agita_
agitas7310593agitas
airth85621023a_irth
aitch105216163a_itch
ajiva1586803ajiva_
ajivas1655133ajivas
ala312463603al__a_
alae45643753al__ae
alan46844083al__an
alar46340073al__ar
alas46358123al__as
alba68328333al_ba_
albas75925393al_bas
albinal937813albinal
alegar739283alegar
aleph10311393al_eph
alfa77624273al_fa_
alfas87219043al_fas
alga57927603al_ga_
algae65319623al_gae
algal66518223al_gal
algas65624933al_gas
alibi7514233ali_bi
alibis8311073alibis
alible8311973alible
alidade936993alidade
alidads936293alidads
alien56425583ali_en
aliens65619213aliens
alif76242143ali__f
alifs86121263ali_fs
alight103816863alight
align65016503ali_gn
aligns75312953aligns
alike95523963ali_ke
aline57243153ali_ne
alined75221403alined
aliner65621983aliner
alines65735223alines
aliped95414283aliped
alist56136783ali_st
alit46155693ali__t
alive85722513ali_ve
alky115920343alky__
alkyd13537093alky_d
alkyds14404363alkyds
alkyl12518043alky_l
alkyls13465723alkyls
alkyne13436863alkyne
allay85620393al_lay
allays94313743allays
ally76935643ally__
allyl85310543ally_l
allyls9437273allyls
alma66333023al_ma_
almahs118611613al_mahs
almas76629773al_mas
almeh106214553al_meh
aloha8513613aloha_
alohas9411703alohas
alpha1049653alpha_
alphas1139513alphas
altar55520643al_tar
alula5317093alula_
alulae6312743alulae
alular6311353alular
alway116113923al_way
always12409133always
amah98927493a__mah
amia66836903ami_a_
amias75831473ami_as
amiga85514813amiga_
amigas95912173amigas
anima74620073anima_
animal85016253animal
animas84418723animas
apian75018333api_an
apical10913903apical
apish105116633api_sh
aria46245423ari_a_
arias55438023ari_as
avian84616053avi_an
axial124515193axi_al
ayahs116813523a__yahs
bimah127013273_bimah
blah98625063bl__ah
calipash1543223calipash
caliph13311403cali_ph
climax1735653climax
clinal8311553clinal
clinch133910353clinch
flinch144010103flinch
flitch14928173flitch
galabiyah1851633galabiyah
galah95917633gal__ah
galyac1235973gal_yac
galyak1445333gal_yak
glia56423153gli_a_
glial66715433gli_al
glias64618493gli_as
glitch12286353glitch
glyph1456473gl_yph
halakah17517963halakah
halalah13429393halalah
halavah16447023halavah
hallah124115403hal_lah
halvah15499833hal_vah
ilia46026823ili_a_
iliac75013493ili_ac
iliad64613463ili_ad
ilial55317843ili_al
kaffiyah2491573kaffiyah
kalian10312163kali_an
kaliph1537873kali_ph
laical8312323laical
laich105920713lai_ch
laigh95515923lai_gh
laith85722103lai_th
liar47229683_li_ar
lich96230843_li_ch
lidar6312723_lidar
ligan67920283_ligan
lilac7311073_lilac
lima65734133_lima_
liman75921603_liman
limas75627633_limas
linac7315413_linac
lipa68425923_lipa_
lira46928683_lira_
liras56021983_liras
litai55216363_litai
litas54923773_litas
lotah85315853_lotah
loyal84513483_loyal
lych126015763_l_ych
palikar1335453palikar
palish114718273pali_sh
pariah114320583pari_ah
playa105812943playa_
playas114612283playas
plica9613373plica_
plicae10410953plicae
plical10411683plical
plinth11310453plinth
rayah116013503_rayah
riyal84413433_riyal
salina64221123salina_
salinas73116093salinas
saliva93110743saliva_
salivas10309603salivas
shibah14387473shibah
shivah15488543shivah
wallah124011993wal_lah
whidah1634803whidah
yah99046353___yah
zillah1836563zillah

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127161704.95022770.9
3Display Results1701700.0632698.4
 (SQL Overall)1786911705.40633054.2
 
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.