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

299 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
pileated11271113(None) 
pileate93815921pileate_
pleated103816631p_leated
bleated104015972_bleated
ciliated11510942ciliated
cleated103417842_cleated
dilated93115822dil_ated
epilated11310752epil_ated
fileted1159092file_ted
filiated12610082filiated
galeated104111572galeated
ideated9310972_ideated
lineated9711062lineated
paleate94120002paleate_
palmated132511002palmated
palpated13249762palpated
picrated132110112picrated
pillaged12298082pillaged
pillared11228082pillared
piloted10310322pil_oted
pinnated11338552pinnated
pipetted1335262pipetted
pirated102515612pi_rated
plated95225772p_l_ated
pleaded113511262p_leaded
pleased103712072p_leased
pleater93916332p_leater
plicated13310642plicated
poleaxed1854812poleaxed
pulsated1136852pulsated
ablated102513443abl_ated
aculeated1247713aculeated
alated75625143_al_ated
alerted82512223_alerted
alienated1047743alienated
belated103520013bel_ated
beleaped1336103beleaped
billeted1137643billeted
bilobated1444973bilobated
bilsted1038033bil_sted
bisected1336203bisected
bleared104211253_bleared
bleater94515303_bleater
bloated104513433_bloated
caseated11310713caseated
caveated1439133caveated
cheated134416343_cheated
chelated142610483chelated
ciliate9514593ciliate_
ciliates10413443ciliates
citrated112712243citrated
cleaned103512003_cleaned
cleared103612463_cleared
cleaved134010483_cleaved
clefted13326753_clefted
collated113615063collated
created104323443_created
cuneated11310103cuneated
defeated132812163defeated
delated93722873del_ated
deleaded1148333deleaded
deleaved1346573deleaved
delegated1238373delegated
deleted93314903dele_ted
depilated1339653depil_ated
dictated1239203dictated
dieted83115493di_e_ted
digested11208163digested
dilate73220693dil_ate_
dilater83515643dil_ater
dilates83220653dil_ates
diluted9248933dil_uted
directed1238233directed
diseased103011703diseased
disrated10915573disrated
disseated11711073disseated
diverted13199583diverted
divested13268213divested
elated74725823_el_ated
elected102812613_elected
elevated12118293_elevated
epilate9314283epil_ate_
epilates10313503epil_ates
falcated1438473falcated
fellated1239563fellated
figeater1236943figeater
filiate10414233filiate_
filiates11412653filiates
filleted1236603filleted
filtrated1345963filtrated
fixated1835533fi_xated
fleeted113310233_fleeted
floated113312703_floated
foliated1249913foliated
foveated1536293foveated
galeate83916783galeate_
gelated93615633gel_ated
gimleted1243973gimle_ted
gleamed11327933_gleamed
gleaned9349423_gleaned
gleeted9379323_gleeted
gloated93511533_gloated
heated104525593__heated
hilted104016043hil__ted
ideate7313683_ideate_
ideates8313723_ideates
iodated9310023_iodated
isleted837523isle_ted
iterated91213813_iterated
jilted144111353jil__ted
kilted113613833kil__ted
lated65240673__l_ated
leaded84221543__leaded
leafed105713873__leafed
leaked114217703__leaked
leaned73422543__leaned
leaped94317773__leaped
leased74722883__leased
leaved105719023__leaved
legated92513983__legated
letted74118543__letted
liberated1299473liberated
librated113110313librated
ligated92414133li_gated
lilted73715373lil__ted
lineate7815153lineate_
liquated1835483liquated
maleate94117543maleate_
maleates103316343maleates
meated94222403__meated
migrated121110493migrated
mileage10299313mileage_
mileages11249693mileages
militated1248803militated
milted93919943mil__ted
misdated121211113misdated
miseaten10310773miseaten
misleared1277453misleared
mismated131111333mismated
misrated111315383misrated
misseated12610113misseated
molested11178243molested
nictated1137793nictated
nidated939863ni_dated
nitrated92213153nitrated
nucleated1247873nucleated
oleate6318883_oleate_
oleates7417833_oleates
opiated1039483opi__ated
oppilated1444583oppil_ated
palaced124110773pal_aced
palate84226783pal_ate_
palates93624933pal_ates
paleae84820293palea_e_
palette93613983palette_
palettes103112833palettes
palleted1139863palleted
palliated1238493palliated
palmate113215233palmate_
palpate113213923palpate_
palpates122613063palpates
parented11912213parented
pated85237843p___ated
patented1188893patented
peaced115818913p__eaced
peaked136117403p__eaked
pealed95322803p__ealed
pelleted1138183pelleted
peltate92013773peltate_
pelted94617753p__elted
pennated11299543pennated
permeated1439353permeated
petted94121523p__etted
phonated1447893phonated
phreaked1834493phreaked
pickaxed2443513pickaxed
picketed17167383picketed
picoted1239213pi_coted
picrate112014143picrate_
picrates122013203picrates
pieced113912103pi_e_ced
pierced12347593pi_erced
pigheaded1743813pigheaded
pigmented1544063pigmented
pilaster1038163pilaster
pilea75123953pilea___
piled85232993pil___ed
pilfered1435853pilfered
pillage103412593pillage_
pillager11278543pillager
pillages113012603pillages
pilled94222753pil__led
pillowed14156383pillowed
pinheaded1644223pinheaded
pinnate93613743pinnate_
pipeage1236203pipeage_
pipeages1336423pipeages
pipestem1443743pipestem
pipette1137943pipette_
pipettes1237563pipettes
pirate82322883pi_rate_
pirates93020323pi_rates
pitted94319593pi__tted
pivoted1336513pi_voted
pixilated1944543pixilated
pixillated2042503pixillated
placated1338453placated
placed114318003p_l_aced
plaited103713893p_laited
planed94420913p_l_aned
planted103516123p_lanted
plate74635113p_l_ate_
platen84518203p_l_aten
plater84427693p_l_ater
plates85432243p_l_ates
platted103614263p_latted
played124815033p_l_ayed
pleached16338063p_leached
plead85818463p_lea__d
pleader103511753p_leader
please84315733p_lease_
pleaser93912343p_leaser
pleases94515483p_leases
pleat74734473p_leat__
pleaters103613783p_leaters
pleather1356653p_leather
pleats85218593p_leat_s
pledged12358613p_ledged
plicate11314513plicate_
plighted1546463plighted
plotted104612373p_lotted
poleaxe1656303poleaxe_
poleaxes1767273poleaxes
polkaed1435323polka_ed
pollenated1345013pollenated
polluted1135433polluted
prated94924923p__rated
preacted132710943p_reacted
preaged11612333p_reaged
predated12513273predated
preheated1539813preheated
prelate9519693prelate_
prelates10418563prelates
prelected1439123prelected
priested1138393priested
probated13410863probated
pronated11414053pronated
prorated11513713prorated
pulsate9510233pulsate_
pulsates1048813pulsates
pupated12319353p_upated
reheated122415003reheated
related83327573rel_ated
released9310243released
relegated1139763relegated
relented92614943relented
repeated113117443repeated
reseated93220263reseated
riveted11258573rive_ted
rivetted12226083rivetted
seated75131053__seated
selected1159783selected
silenced1136273silenced
silenter838873silenter
silted74020013sil__ted
sinuated938403sinuated
situated938023situated
sklented1335053sklented
slated75028313_sl_ated
sleaved113611133_sleaved
sleeted83113223_sleeted
solated83618023sol_ated
solvated12237443solvated
spicated13309903spi_cated
spoliated1246913spoliated
sulcated11310373sulcated
sulfated1238833sulfated
sweated113411543_sweated
tailgated1145123tailgated
talented938423talented
teated74924023__teated
threated1259203threated
tilted74616863til__ted
titrated92611683titrated
toileted936993toile_ted
tolerated1049123tolerated
treated83618703_treated
unheated121514553unheated
unleaded10411333unleaded
unleased9310713unleased
unletted9310313unletted
unseated91317683unseated
upleaped1334333upleaped
valeted1139013vale_ted
valuated12239203valuated
vibrated14228383vibrated
violated1237883violated
vitiated12289223vitiated
wilted103915713wil__ted

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.1701051123.5
2DLD Change Limit1461622997.36019859.0
3Display Results2992990.1262373.0
 (SQL Overall)1786912997.65623340.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.