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

497 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
aiglets8401291(None) 
aglets73915681a_glets
aiglet74224191aiglet_
aigrets82810531aigrets
giglets93211551giglets
piglets103311791piglets
wiglets113411421wiglets
aglet65534142a_glet_
aidless83612072aidless
aigret73720022aigret_
aimless93610812aimless
airless73712042airless
aisles64721142aisle_s
amulets939922amulets
anglers84014822anglers
angles74426702angle_s
anklets114310412anklets
applets115710062applets
argles75218482argle_s
armlets94610062armlets
auklets11298572auklets
billets94516152billets
diglots9299502diglots
eaglets84111662eaglets
filets94718952fi_lets
fillets103414752fillets
giblets103210422giblets
giglet83920272giglet_
giglots9367862giglots
gimlets10338432gimlets
goglets9379782goglets
guglets9369692guglets
inlets63915572_inlets
islets64513082_islets
kinglets13318582kinglets
millets94216842millets
piglet93420922piglet_
piolets93513192piolets
reglets83512982reglets
riblets93412552riblets
rillets74216152rillets
ringlets92910232ringlets
signets83311502signets
singlets93611472singlets
sniglets9276812sniglets
violets102210002violets
wigless11359672wigless
wiglet105519152wiglet_
willets104414322willets
winglets12299592winglets
abeles84719393abele_s
abets75621673a__bets
ables75935543a_ble_s
ablest84721833a_blest
aculeus937513aculeus
addles84216603addle_s
adults7299953adul_ts
afreets1037013afreets
agates76121343a_gates
ageless8310343ageless
agents74816293a_gents
agers65027853a_g_ers
ages55844593a_g_e_s
aggers85817793a_ggers
aggies83515513aggie_s
aggress935593aggress
agile65122263agile__
agilely1135123agilely
agility1148653agility
agists75713173a_gists
agleam9158623a_gleam
aglee65728493a_gle_e
agley96917333a_gle_y
agrees74915323a_grees
agues64919053a_gue_s
aiblins9311473aiblins
aiders74524633ai_ders
aides65336603ai_de_s
aigrette946833aigrette
aigrettes1046393aigrettes
ailed66240283ai_le_d
ailments1039433ailments
ails45654713ai_l__s
aimers84621913ai_mers
aiolis6316843aiol_is
airers64922313ai_rers
airest63825263ai_rest
airglows1243463airglows
airiest74221013airiest
airlifts1143633airlifts
airts55626343ai__rts
aisle55223193aisle__
aisled74516183aisle_d
aits46355533ai___ts
aivers94822323ai_vers
alecs76620733a__lecs
alefs87319663a__lefs
alerts64418223a__lerts
ales47067103a__le_s
alights113211433alig_hts
aligners9117573aligners
allees64521483a_llees
alleys95113303a_lleys
allots64019173a_llots
alts46639903a__l_ts
amblers115213563amblers
ambles105121863amble_s
amoles84122193amole_s
amplest11312333amplest
amulet8419573amulet_
analects1047703analects
aneles64626293anele_s
angels74416173ang_els
angelus8418463angelus
angers75222543ang_ers
angle64528873angle__
angled84219093angle_d
angler74017863angle_r
anglos74413913angl_os
angsts738863ang_sts
ankles104818383ankle_s
anklet105618733anklet_
annulets845813annulets
anoles64827433anole_s
antlers74014743antlers
apples104315763apple_s
applet105917433applet_
argents84014853argents
argle65421563argle__
argled85314553argle_d
argots74116033arg_ots
arguers8489033arguers
argues74516413argue_s
argyles1136053argyle_s
arles56735743a_rle_s
armets84918353a_rmets
armless9369943armless
armlet84118193armlet_
artless73712513artless
ashlers10319583ashlers
ashless10318453ashless
assets65617663a_ssets
athlete1068083athlete
athletes1157883athletes
augers73818703aug_ers
aughts104710243aug_hts
augites8312183augites
augments1137833augments
auklet104216833auklet_
avocets1235453avocets
avosets1036663avosets
aweless1038723aweless
awless939263a_wless
awnless1035923awnless
axles125219473a_xle_s
azaleas1636993azaleas
azoles154614613azole_s
baguets1037483baguets
bailees93914383bai_lees
bailers94221353bai_lers
baileys12388933bai_leys
ballets93719513ballets
bangles103617413bangle_s
begets96215523beg_ets
beignets11155373beignets
bibles104617643bible_s
bibless11439173bibless
bidets95215533bi_dets
biggest1138143biggest
biggety1434433biggety
bights124417963big_hts
bigness1038193bigness
bigots95015133big_ots
biles75542143bi_le_s
bilges94915633bilge_s
billers94720833billers
billet86029723billet_
birlers93813003birlers
birles84920643birle_s
blets75324943__blets
bogles95020833bogle_s
buglers105115323buglers
bugles94822443bugle_s
bullets93516393bullets
cablets114216343cablets
callets93821703callets
camlets114314623camlets
capelets1268603capelets
caplets114914523caplets
chalets122813473chalets
cigarets1145473cigarets
circlets1235663circlets
civets115212543ci_vets
collets93517903collets
culets85518513_culets
cullets94015613cullets
cutlets94113653cutlets
cygnets1333813cygnets
daggles103611913daggle_s
danglers103610593danglers
dangles93618423dangle_s
dialects11126003dialects
dialers83614303dialers
diets66026643di__ets
digest84019623dig_est
digests93610613digests
diggers104413393diggers
dights114016963dig_hts
digits84114533dig_its
diglot83014333diglot_
digress938323digress
dingles93818323dingle_s
dipnets10109033dipnets
doglegs1034783doglegs
driblets11266093driblets
eagles73819163eagle_s
eaglet73722583eaglet_
eggless935663eggless
egrets72712243_egrets
eights103618983eig_hts
engluts834533engluts
eyelets1057523eyelets
failles102914133faille_s
fangless1237663fangless
fidgets12388763fidgets
fights133816553fig_hts
figments1446943figments
filers94623723fi_lers
files85441273fi_le_s
filet85540163fi_let_
fillers104320213fillers
filles94224523fille_s
fillet95027083fillet_
finless102810783finless
fogless1138193fogless
froglets1235263froglets
fugles104715783fugle_s
gadgets10348683gadg_ets
gaggles103512593gaggle_s
gainless9117403gainless
gallets83517403gallets
gantlets9308903gantlets
gargets94614573garg_ets
garglers10418263garglers
gargles94214893gargle_s
gelts65924613__gelts
gets55442483__g_ets
gibbets12417723gibbets
giblet93418893giblet_
gigglers11297403gigglers
giggles103312933giggle_s
giglot84013133giglot_
gigots83911953gig_ots
gigues8129003gigue_s
gillers84216903gillers
gillnets934733gillnets
gilts64924263gi_l_ts
gimlet93716663gimlet_
gleds75417893__gleds
glees65027593__glees
gleets75315053__gleets
glens66519853__glens
gleys96514853__gleys
gluts66120133__gluts
goblets103210183goblets
goglet84618583goglet_
guglet84018223guglet_
gullets84013713gullets
gurglets10355543gurglets
hagglers13326623hagglers
haggles123312483haggle_s
hailers104017263hai_lers
hairless1157413hairless
hairnets1195633hairnets
hamlets123211403hamlets
harslets1137833harslets
haslets102510863haslets
higglers13297233higglers
higgles123911803higgle_s
highest1439563highest
hights133716893hig_hts
hillers103718733hillers
hilts86924413hi_l_ts
hipless12399923hipless
hitless103211193hitless
hoggets12498323hoggets
howlets13329223howlets
idlers74012813_idlers
idles66720123_idle_s
idlest74014863_idlest
igloos738033_igloos
iglus6609933_igl_us
ileus54616893_i_leus
illest63615723_illest
ingles74420873ingle_s
inlet53732403_inlet_
insets64016133_insets
isles54220563_isle_s
islet54527553_islet_
jagless1537103jagless
jailers144114043jai_lers
janglers16319373janglers
jangles154015683jangle_s
jiggers164010183jiggers
jiggles164111433jiggle_s
jilts124717413ji_l_ts
jinglers16408763jinglers
jingles153816383jingle_s
keglers12277773keglers
killers114215583killers
kilts95122183ki_l_ts
kingless13288693kingless
kinglet123114043kinglet_
kinless113310273kinless
kismets13306883kismets
langleys1245103langleys
languets987243languets
legless838013legless
lets47147943___lets
lidless8309273lidless
ligates82318383ligates
ligers75022043lig_ers
lights104519913lig_hts
ligules82210923ligule_s
lilts55822803li_l_ts
limpets11329783limpets
linnets739833linnets
lipless9259553lipless
lisles63416283lisle_s
loggets9378913loggets
maglevs1334693maglevs
magnets10311143magnets
mailers94420333mai_lers
mailes84329113mai_le_s
mailless10248583mailless
maillots1037473maillots
mallets93318493mallets
manglers113311903manglers
mangles104021463mangle_s
mantlets104611203mantlets
martlets103310483martlets
midgets113910253midgets
midlegs1156323midlegs
miggles113512033miggle_s
mights123516253mig_hts
milers84625163mi_lers
miles74645073mi_le_s
millers93621343millers
milles84526563mille_s
millet84030743millet_
milts75430713mi_l_ts
minglers113011293minglers
mingles103719003mingle_s
minuets9259853minuets
missets94516573missets
mullets93614783mullets
nailers73215893nai_lers
nailsets834553nailsets
neglects1144383neglects
nidgets9358143nidgets
niggers93111323niggers
nigglers10307253nigglers
niggles93512203niggle_s
nighest11310693nighest
nights104117723nig_hts
nuggets936383nuggets
nutlets74111253nutlets
oglers74313183_oglers
ogles65223183_ogle_s
oilers64721193oi_lers
omelets938333omelets
outlets73616363outlets
owlets93110393_owlets
painless10108343painless
paisleys1333343paisleys
palets85122313_palets
pallets93919303pallets
pargets105215193parg_ets
partlets102811513partlets
pegless1038053pegless
pellets94014783pellets
pickets154314183pickets
pigments1337343pigments
pignuts1035613pignuts
pigouts1037593pigouts
pigpens1235503pigpens
piles74742613pi_le_s
pileus84514943pi_leus
pilots84018873pi_lots
piolet83225643piolet_
pipets105714773pi_pets
piquets1836603piquets
pullets94015163pullets
quillets17256823quillets
raggles93813283raggle_s
railers74420663rai_lers
rainless8129703rainless
reflets103513153reflets
reglet73724233reglet_
regrets83212923regrets
relets64025673_relets
ribless93410343ribless
riblet84222443riblet_
rickets134915093rickets
ridleys11145783ridleys
riflers103512193riflers
rifles94217703rifle_s
riggers93613843riggers
rights104019333rig_hts
riles55343643ri_le_s
rilles64725503rille_s
rillet64828853rillet_
rimless9369363rimless
ringlet82818173ringlet_
ripplets12316733ripplets
rivets94417113ri_vets
rivulets1174753rivulets
runlets73310773runlets
sailers73822323sai_lers
sailless82410373sailless
sallets73719653sallets
samlets93813553samlets
sidlers83414233sidlers
sidles74721153sidle_s
sighers113712183sighers
sighless1276553sighless
sights103818013sig_hts
siglos7311473sigl_os
signees83510803signees
signers84714443signers
signet73621153signet_
silents73514493si_lents
sillers73822103sillers
silts55330823si_l_ts
singles83520433single_s
singlet84120113singlet_
sinless73014213sinless
sippets113310183sippets
skillets12226823skillets
sniglet83612413sniglet_
stylets10369213stylets
sublets92616703sublets
tablets94714383tablets
tailers73720183tai_lers
tailles72516473taille_s
tailless8239083tailless
tanglers92911973tanglers
tangles83920043tangle_s
targets84314223targ_ets
tartlets8289663tartlets
tickets134113683tickets
tieless72512563tieless
tigers75616513tig_ers
tights104015853tig_hts
tiglons837343tiglons
tigress836093tigress
tilers63523503ti_lers
tiles55542103ti_le_s
tillers73418743tillers
tilts55325613ti_l_ts
tinglers93710593tinglers
tingles83818323tingle_s
tipless92610063tipless
tippets11339373tippets
titles63719923title_s
toilets74112913toilets
tonlets73212503tonlets
triolets83410143triolets
triplets103510263triplets
tugless837383tugless
twigless1293663twigless
valets93715623_valets
varlets10411573varlets
veinlets11144833veinlets
vilest9416843vi_lest
violet92620923violet_
waggles123812003waggle_s
wailers103916803wai_lers
wallets103914833wallets
wanglers123310033wanglers
wangles113416933wangle_s
wavelets1436153wavelets
wickets164010943wickets
widgets12318453widgets
wigglers13257213wigglers
wiggles123312463wiggle_s
wights133315783wig_hts
wiles85437873wi_le_s
willers103517913willers
willet95124833willet_
wilts85023503wi_l_ts
wingless122910023wingless
winglet113115983winglet_
winless103212283winless
witless103310983witless
zibets1737743zi_bets
zipless18276303zipless

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 Filter1786911340270.436409841.7
2DLD Change Limit1340274976.81319672.2
3Display Results4974970.1702923.5
 (SQL Overall)1786914977.41924085.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.