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

195 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
aliyot9361171(None) 
aliyos9349531aliyos
alight103816862alight
aliquot1646492aliquot
alist56136782ali_st
alit46155692ali__t
aliya83713482aliy_a
aliyah12397492aliyah
aliyas93911802aliyas
allot54933872al_lot
galiot72322592gali_ot
galipot1049542galipot
lirot5430032_lirot
talipot949722talipot
abbot9318453a_bbot
adios65822863adi_os
adit56443653adi__t
afoot8420113a_foot
agio57828453agi_o_
agios65919863agi_os
agist66325583agi_st
agorot7415003agorot
airt45757783a_i_rt
ait38093903a_i__t
alamo7418143alamo_
alamos8415003alamos
alant55742293al_ant
albeit8314343albeit
albino839933albino_
albinos937653albinos
aldol61212333al_dol
alert54740653al_ert
algor6513053al_gor
alias55834603ali_as
alibi7514233ali_bi
alibis8311073alibis
alible8311973alible
alidad838883alidad
alien56425583ali_en
alienor7116303alienor
aliens65619213aliens
alif76242143ali__f
aliform1247033aliform
alifs86121263ali_fs
alights113211433alights
align65016503ali_gn
aligns75312953aligns
alike95523963ali_ke
aliment9316703aliment
alimony1236013alimony
aline57243153ali_ne
alined75221403alined
aliner65621983aliner
alines65735223alines
aliped95414283aliped
aliquots1743643aliquots
alive85722513ali_ve
aliyahs13395323aliyahs
alky115920343alky__
alkyd13537093alky_d
alkyds14404363alkyds
alkyl12518043alky_l
alkyls13465723alkyls
alkyne13436863alkyne
allod64418383al_lod
allots64019173al_lots
allow85420663al_low
alloy85519973al_loy
alloys94014563alloys
ally76935643ally__
allyl85310543ally_l
allyls9437273allyls
almost81014433almost
alnico877943alnico_
alnicos985533alnicos
aloe45540193al__oe
aloft8423433al_oft
aloof83521573al_oof
alow75328593al__ow
alright1148853alright
also46423443al_so_
alt36467963al___t
altho86312603altho_
alto47831263al_to_
altos55822953al_tos
amido85720983amido_
amidol9489573amidol
amidst94913233amidst
amigo86515473amigo_
amigos94511213amigos
amino75425503amino_
anion55028813ani_on
antipot9312923antipot
anyon85615223a_nyon
apricot111010183apricot
argot67728653a_rgot
aright103817663aright
aristo6414033aristo
aroynt9312893aroynt
ascot76522513a_scot
atilt54828473ati_lt
avion84218343avi_on
aviso85713963aviso_
avisos95410483avisos
axiom143913593axi_om
axion1211316913axi_on
azido155411543azido_
ballot84624093bal_lot
bigot84828323_bigot
blight124114623blight
blot65842323bl__ot
calico103414433calico_
calicos113913493calicos
client8316343client
clift106422193cli_ft
clipt96324273cli_pt
cloot76127053cl_oot
clot66542423cl__ot
dicot85429093_dicot
divot95723073_divot
elicit8417203elicit
elint55436473eli_nt
fliest94718433fliest
flight134014813flight
flint87333503fli_nt
flirt87424753fli_rt
flit76539273fli__t
fluyt114614203fluy_t
galiots82311323gali_ots
galipots1145213galipots
galliot82214133galliot
gallipot1145943gallipot
galloot82814223galloot
galoot72719163gal_oot
gigot74023073_gigot
glint66830183gli_nt
griot65328413gri_ot
guyot9314523_guyot
halcyon1543923halcyon
halibut1289053halibut
halidom1386443halidom
hallot95426783hal_lot
haricot12311963haricot
idiot6718863idi_ot
layout9513703_layout
licht104723493_licht
licit74327683_licit
lido56028163_lido_
lidos65219883_lidos
lift76942723_li_ft
light94429603_light
lilo46731563_lilo_
lilos55821873_lilos
lilt46349943_li_lt
limit73126343_limit
limo65529733_limo_
limos75320813_limos
lino46343373_lino_
linos55631503_linos
lint416266233_li_nt
lion46334443_li_on
liroth938383_liroth
list47055343_li_st
lit39377313_li__t
loot46955823_l_oot
lot38179263_l__ot
maillot9312173maillot
malison939693malison
manihot121112053manihot
melilot9311083melilot
olio46829673oli_o_
olios54520853oli_os
paletot9413713paletot
paliest93021603paliest
picot95031013_picot
pilot77435063_pilot
pinot78737293_pinot
pivot106523873_pivot
pliant83918823pliant
plight123513363plight
plot66141233pl__ot
riot45947213_ri_ot
ryot75528563__ryot
salient7419763salient
sliest66621953sliest
slight103416003slight
slipout949083slipout
slipt76627483sli_pt
slit46250103sli__t
slot46049833sl__ot
spigot9312603spigot
talion6317713tali_on
talipots1045623talipots
tricot8317753tricot
valiant10314623valiant

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 Filter1786911127160.436409841.7
2DLD Change Limit1127161955.62620034.8
3Display Results1951950.0603250.0
 (SQL Overall)1786911956.12229188.3
 
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.