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

259 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
perilled1141011(None) 
periled10316321peri_led
prilled104713001p_rilled
devilled1336742devilled
drilled94711672_drilled
frilled113911602_frilled
grilled94012832_grilled
imperilled1543632imperilled
pedalled1246932pedalled
pedicled1436462pedicled
pencilled1445642pencilled
periblem1445512periblem
perilla9311232perill_a
perillas10310822perillas
perished14310082perished
petalled1138702petalled
petioled1137992petioled
pilled94222752p__illed
prebilled1445062prebilled
predrilled1443452predrilled
prefilled1535512prefilled
rebilled11318052rebilled
redrilled1145352redrilled
refilled12278672refilled
rerolled93010052rerolled
rilled74525652__rilled
shrilled1246862shrilled
thrilled1235492thrilled
trilled84116312_trilled
aeried74221863aeri__ed
aerified121310133aerified
anvilled1236483anvilled
ariled75620323_ari_led
auricled11135703auricled
begalled1236023begalled
belled94626183be__lled
berimed124912283beri_med
beringed1298173beringed
bevelled14327793bevelled
billed94224903__billed
brailled1147193brailled
bridled113611143_bridled
carolled1138833carolled
cavilled1436733cavilled
ceiled94114953ce_i_led
celled94420323ce__lled
chilled133310933_chilled
defiled124013103defi_led
derailed102410403derailed
derided102914253deri_ded
derived123912763deri_ved
deviled124112183devi_led
dilled84122223__dilled
driller84311883_driller
drolled93810223_drolled
enisled82510223_enisled
enrolled967963enrolled
eviller1056673_eviller
exiled144712463_exi_led
felled103720303fe__lled
ferreled1234843ferreled
ferrelled1343933ferrelled
ferruled1263923ferruled
feruled11318423fer_uled
filled104922263__filled
friller104111743_friller
gelled84718893ge__lled
gerbille1144613gerbille_
gerbilles1244013gerbilles
gilled84521633__gilled
grille74315743_grille_
griller84513353_griller
grilles83715023_grilles
heiled104415613he_i_led
helled104024703he__lled
heralded1335443heralded
hilled104022223__hilled
imperiled1445493imperi_led
jelled144916063je__lled
jewelled1934333jewelled
kerneled1344033kerneled
kernelled1443733kernelled
killed113918773__killed
levelled12327443levelled
medalled1246893medalled
melled95023023me__lled
merited10313853meri_ted
metalled1148983metalled
milled94326173__milled
muralled1136423muralled
nilled73919453__nilled
overalled1339073overalled
overbilled1645423overbilled
overfilled1745053overfilled
overkilled1844273overkilled
palled94625163p__alled
panelled1138963panelled
panicled13106783panicled
parallel1047473parallel
parceled1338343parceled
parcelled1445783parcelled
parled94626293par__led
paroled104217633par_oled
parslied1137823parslied
patrolled1245713patrolled
pealed95322813pe__aled
pearled10411553pe_arled
pearlized2145563pearlized
pebbled1445403pe_bbled
pedaled113711893pe_daled
pedaller1136093pedaller
peddled123410543pe_ddled
pedicle1238973pedicle_
pedicles1338683pedicles
peeled94119713pe__eled
peined94918843pe_i_ned
peised94817683pe_i_sed
pellet83326553pe__llet
pelted94617763pe__lted
penciled1337823penciled
penciller1344953penciller
penile82219603peni_le_
peopled1238503pe_opled
percale11314093percale_
percales12313803percales
perched154713243per_ched
perdured12287403perdured
perfumed1654543perfumed
perfused1445833perfused
periblems1543483periblems
perigee101113393peri_gee
perigees1189503perigees
peril75425953peri_l__
periling11316863periling
perilling12410003perilling
perilous10310693perilous
perils84121853peri_l_s
perilune1046983perilune
perilunes1147163perilunes
perinea9313033peri_nea
period9314983peri__od
periodid1248163periodid
peripter1278753peripter
perique1837523perique_
periques1937653periques
perishes13313753perishes
perjured18286273perjured
perked134617693per__ked
perlite9317323perlite_
perlites10316363perlites
permed115217353per__med
permitted1446653permitted
permuted1336713permuted
perplex1836153per_plex
perplexed2143263perplexed
persisted1247143persisted
peruked14367893per_uked
perused103112193per_used
pervaded1535373pervaded
pestled102711443pe_stled
petaled103614153pe_taled
petiole9311303petiole_
petioles10311643petioles
petrified1548333petrified
pettled103611513pe_ttled
piled85232993p__i_led
polled94022003p__olled
portaled11239203portaled
prechilled1843893prechilled
prefiled143310573prefiled
prerinsed1246323prerinsed
priced115018883p_ri_ced
pricked164613833p_ricked
prickled17358073p_rickled
prided103618033p_ri_ded
pried84426863p_ri__ed
prigged12398933p_rigged
prill74117943p_rill__
prills84015613p_rill_s
primed115118913p_ri_med
primmed14388853p_rimmed
primped14479153p_rimped
prinked143412163p_rinked
printed104016373p_rinted
prised94322203p_ri_sed
prissed103311263p_rissed
prized184415393p_ri_zed
prowled13309913p_rowled
puerile9310093pueri_le_
puerilely1443403puerilely
pulled94322193p__ulled
purfled13248733pur_fled
purified1438743purified
purled94520753pur__led
purpled12299783pur_pled
quilled17329283_quilled
rebelled113110323rebelled
recalled11310803recalled
redialed10310793redialed
redialled1145883redialled
refelled122810163refelled
refiled114318653refi_led
refilmed14235813refilmed
regilded1135543regilded
reoiled84316853reoi_led
repelled113111583repelled
repolled11359623repolled
rerigged1136243rerigged
reroller8258753reroller
resiled84621983resi_led
retiled84420513reti_led
retitled9339553retitled
revelled123712733revelled
reviled114417923revi_led
rifled104115003__rifled
riled65833253__ri_led
rille55728733__rille_
rilles64725503__rilles
rillet64828853__rillet
rolled74220243__rolled
scrolled1137053scrolled
sepalled1156903sepalled
seriated92717023seriated
serifed11811463seri_fed
seriffed1594973seriffed
shilled113313623_shilled
shriller1136823shriller
skilled123110863_skilled
speiled104412123spe_i_led
spelled103714733spe__lled
spilled103613623_spilled
spiralled1244403spiralled
stilled83314783_stilled
strolled937813strolled
swilled113611833_swilled
tendrilled1242963tendrilled
thralled1245803thralled
thriller1165553thriller
tilled74722953__tilled
trifled113711963_trifled
triller74215893_triller
tripled104113833_tripled
trolled84312263_trolled
twilled11398033_twilled
unbilled1188693unbilled
undrilled1146663undrilled
unfilled1298383unfilled
unmilled1197853unmilled
unrifled1237423unrifled
unrolled9610413unrolled
untilled9710563untilled
unwilled1277823unwilled
veiled103714543ve_i_led
verified151510393verified
welled103820213we__lled
willed104722453__willed
yelled104116253ye__lled
zorille1636673zorille_
zorilles1736123zorilles

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622598.48617223.9
3Display Results2592590.0932784.9
 (SQL Overall)1786912599.01519821.5
 
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.