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

476 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
piloted1031032(None) 
picoted1239211picoted
pivoted1336511pivoted
bigoted11258402bigoted
bilobed1235912bilobed
bilsted1038032bilsted
dilated93115822dilated
diluted9248932diluted
epilated11310752epilated
fileted1159092fileted
hilted104016042hil_ted
jilted144111352jil_ted
kilted113613832kil_ted
lilted73715372lil_ted
milted93919942mil_ted
pelted94617762pel_ted
picotee11311472picotee
pileated112711132pileated
piled85232992pil__ed
pilled94222752pil_led
pillowed14156382pillowed
pilose84514242pilose_
pilot77435062pilot__
pilots84018872pilot_s
pirated102515612pirated
pitted94319592pi_tted
plated95225772p_lated
plotted104612372p_lotted
plotzed19376222p_lotzed
plowed124213202p_lowed
ployed124310562p_loyed
rioted73416372ri_oted
siloed74615302silo_ed
silted74020012sil_ted
tilted74616862til_ted
wilted103915712wil_ted
ablated102513443ablated
abluted10188363abluted
ailed66240283ail__ed
airted74214503ai_rted
alated75625153_alated
allotted986873allotted
allowed111610083allowed
alloyed11158033alloyed
azoted16388593_azoted
balloted1189043balloted
belated103520013belated
beloved13188393beloved
belted94020633bel_ted
bighted142810923bighted
bilged105513183bil_ged
bilked134012943bil_ked
billed94224903bil_led
billeted1137643billeted
billowed14137063billowed
bilobated1444973bilobated
bilsteds1134273bilsteds
bitted94418483bi_tted
bloated104513433_bloated
blotted103911833_blotted
blowed125016693_blowed
bolted94617803bol_ted
booted94822733_booted
celotex1635023celotex
ciliated11510953ciliated
cisted95217523ci_sted
cited84421953ci__ted
cloned94518803_cloned
closed95317963_closed
clothed134010283_clothed
clotted104011823_clotted
clouted104212163_clouted
cloyed125111563_cloyed
colored10313473colored
coted85033853__coted
delated93722873delated
deleted93314913deleted
demoted114313543demoted
denoted93512763denoted
depilated1339653depilated
devoted124111093devoted
dialoged1146693dialoged
dieted83115493di_eted
dighted132511493dighted
dilate73220693dilate_
dilater83515653dilater
dilates83220663dilates
dilled84122223dil_led
dilute72911803dilute_
diluter8319663diluter
dilutes82911973dilutes
dinted84419843di_nted
dittoed936733dittoed
doted75227073__doted
elated74725823_elated
eloped95914143_eloped
eluted74915263_eluted
emoted94614923_emoted
epidote1037393epidote_
epidotes1147023epidotes
epilate9314283epilate_
epilates10313503epilates
epilogued1342293epilogued
escoted1038183escoted
fagoted1236073fagoted
felted103714653fel_ted
filched16307423filched
filed95331903fil__ed
filiated12610083filiated
filled104922263fil_led
filleted1236603filleted
filmed124610363fil_med
filose96112503filose_
filter94517633fil_ter
fisted104218703fi_sted
fitted104716663fi_tted
fixated1835533fixated
flinted114411893flinted
flirted11428673flirted
flited104616583_flited
flitted114011643flitted
floated113312703_floated
flouted113210813_flouted
flowed133513763_flowed
fluted104917163_fluted
flyted13378773_flyted
footed104418623_footed
galoped11138083galoped
garoted9710133garoted
gelated93615643gelated
gifted114510703gi_fted
gilded94413223gil_ded
gilled84521633gil_led
gillied95512313gillied
gimleted1243973gimleted
girted83912873gi_rted
gitted84015053gi_tted
glinted9399373glinted
gloated93511533_gloated
globed104811763_globed
glouted9429713_glouted
gloved114811873_gloved
glowed114913833_glowed
glozed173711223_glozed
haloed104717603halo_ed
halted105019603hal_ted
highted152710163highted
hilled104022223hil_led
hilloaed12136923hilloaed
hilloed113211293hilloed
hinted104318323hi_nted
histed104420243hi_sted
hooted104422663_hooted
ingoted939183ingoted
ironed74916013_ironed
isleted837523isleted
jilter133512513jil_ter
jolted143510633jol_ted
killed113918773kil_led
kilned11368393kil_ned
kilorad1245393kilorad
kiloton1196313kiloton
kilter103714343kil_ter
kited105120093ki__ted
kitted115114833ki_tted
lated65240673__lated
lichted13268803lichted
lifted104413523li_fted
ligated92414143ligated
lighted122913503lighted
lilied73913213lil_ied
limited102310233limited
linted74021823li_nted
listed74322833li_sted
litotes7311183litotes
lobed86022133__lobed
lofted103811893__lofted
looed64626133__looed
looted74421113_looted
loped85128333__loped
lotted74222403__lotted
louted74920693__louted
loved95021363__loved
lowed95233903__lowed
loxed135017053__loxed
luted64826143__luted
malted94819863mal_ted
melted94219063mel_ted
miaoued1034583miaoued
miaowed1333883miaowed
milded104416153mil_ded
milked134612573mil_ked
milled94326173mil_led
milord999573milo_rd
milter84921233mil_ter
minored10310103minored
minted94220583mi_nted
minuted10329503minuted
misted93625823mi_sted
molted94217473mol_ted
mooted94120373_mooted
mulcted12296693mulcted
nidated939863nidated
nilled73919453nil_led
noted65123843__noted
oiled64429473oil__ed
oilseed835783oilseed
opiated1039483opi_ated
oppilated1444583oppilated
painted104214633painted
palaced124110783palaced
palate84226793palate_
palates93624943palates
paled85538723pal__ed
palled94625163pal_led
palleted1139873palleted
palmated132511003palmated
palmed114314643pal_med
palpated13249763palpated
palped114513643pal_ped
palsied102911303palsied
palter84423263pal_ter
panted95024823p_anted
paroled104217633paroled
parotid102915513parotid
parroted1158843parroted
parted94228683p_arted
pasted94426903p_asted
pated85237843p__ated
patted94724683p_atted
pelite84323003pelite_
pelites93821993pelites
pelleted1138203pelleted
pelota8612833pelot_a
pelotas9410723pelotas
peloton938743peloton
pelter83321623pel_ter
petted94121523p_etted
peyote1139853peyote_
peyotes1238483peyotes
philomel1544083philomel
philter12108213phil_ter
philtred14114183philtred
phloem1335713phlo_em
phloxes1935513phloxes
phoned124014553p_honed
photoed1338913p_hotoed
piaffed1693753piaffed
piaster93012883piaster
picked154421313pi_cked
picketed17167383picketed
pickled164011883pickled
picot95031013picot__
picotees1247113picotees
picots104616443picot_s
picrated132110113picrated
piddled123311253piddled
pieced113912103pi_eced
pied75035363pi___ed
pierced12347593pierced
piffled16366403piffled
pigged114214153pi_gged
pigweed1465093pigweed
piked125623313pi__ked
pilaster1038163pilaster
pile65649693pil__e_
pilea75123953pil__ea
pileate93815923pileate_
pilei74021783pil__ei
piles74742613pil__es
pilfer1139163pil_fer
pilfered1435853pilfered
pillaged12298093pillaged
pillared11228093pillared
pilloried1265313pilloried
pilotage1145373pilotage
pilotages1245503pilotages
piloting1139693piloting
pilotless1143993pilotless
pilous84717753pilo_us
pilsner935343pilsner
pilule8411123pilule_
pilules9510623pilules
pimped134913483pi_mped
pimpled14289193pimpled
pinched153812453pinched
pined85935323pi__ned
pinged104321383pi_nged
pinioned1137513pinioned
pinite8321243pinite_
pinites9319533pinites
pinked134819883pi_nked
pinnated11338553pinnated
pinned94818383pi_nned
pinole83218783pinole_
pinoles93418703pinoles
pinones94717073pinones
pinot78737293pinot__
pinots85920273pinot_s
pintoes95117713pintoes
pinweed1346933pinweed
piolet83225643pi_olet
piolets93513193piolets
piped105123163pi__ped
pipetted1335263pipetted
pipped104516543pi_pped
piqued1836213pi_qued
pirate82322883pirate_
pirates93020333pirates
pirogen1038263pirogen
pished124817063pi_shed
pissed94816933pi_ssed
piste75824603pi_ste_
pistes85325633pi_stes
pistoled11259593pistoled
pitched153512923pitched
pithed124615613pi_thed
pitied94017253pi_tied
pivot106523873pivot__
pivotal1245433pivotal
pivotmen1542653pivotmen
pivots115111903pivot_s
pixilated1944543pixilated
placed114318003p_laced
plaited103713893plaited
planed94420913p_laned
planted103516123planted
plate74635113p_late_
platen84518203p_laten
plater84427693p_later
plates85432243p_lates
platted103614263platted
played124815033p_layed
pleated103816633pleated
pled75231433p_l__ed
plicated13310643plicated
plied85118593p_l_ied
plighted1546463plighted
plinked143910893plinked
plod76723273p_lo__d
plodded1265563p_lodded
plonked14348103p_lonked
plopped11288773p_lopped
plot66141233p_lot__
plots75025673p_lot_s
plotter94113663p_lotter
plotty11208853p_lotty
plotz164617003p_lot_z
plotzes18317703p_lotzes
plover115312613p_lover
plower114315063p_lower
plumed114412883p_lumed
plutei8408903p_lutei
pointed103813983pointed
poisoned1136953poisoned
poked125425393p__oked
poled84934843p__oled
policed123212233policed
polite83625073polite_
politer92417073politer
polkaed1435323polkaed
polled94022003pol_led
polluted1135433polluted
polyped1537173polyped
pooed85226243p__ooed
poohed123912523p_oohed
pooled94619813p_ooled
pooped113915943p_ooped
pored85234513p__ored
ported94223243p_orted
posed85828413p__osed
posited10511493posited
posted93722493p_osted
potted94624013p_otted
pouted94021393p_outed
poxed154817863p__oxed
prated94924923p_rated
priested1138393priested
prilled104713003pril_led
printed104016373printed
prisoned1138813prisoned
probed114114823p_robed
prologed12189213prologed
promoted13310543promoted
proofed13138723proofed
prosed94921093p_rosed
protea82214763p_rotea
protei82615313p_rotei
proteid103513673p_roteid
protend104012793p_rotend
proved125016033p_roved
psiloses1036443psiloses
psilotic1245773psilotic
puled84926523pul__ed
pulled94322193pul_led
pulped114612533pul_ped
pulsated1136853pulsated
pulsed94013723pul_sed
punted94618713p_unted
pupated12319353pupated
putted94220253p_utted
quilted17319313quil_ted
quoted16359453_quoted
related83327573related
revoted114314153revoted
rifted104115313ri_fted
righted122912143righted
riled65833253ril__ed
rilled74525653ril_led
rioter64817283ri_oter
riposted11216933riposted
riveted11258573riveted
rooted75424003_rooted
salted74121203sal_ted
saluted84511713saluted
scooted103612283scooted
sifted104313673si_fted
sighted123111523sighted
silked114314813sil_ked
sited65130743si__ted
slated75028313_slated
slitted83513313slitted
sloped94216853_sloped
slotted84613883_slotted
slowed104617073_slowed
snooted84213283snooted
solated83618023solated
soloed74515743solo_ed
sooted73922593_sooted
spicated13309903spicated
spiled94621993spil__ed
spilled103613623spil_led
spirited1148973spirited
spirted103913073spi_rted
spited94820443spi__ted
spitted103912703spi_tted
splinted11369253splinted
stilted83511473stil_ted
tailored936203tailored
taloned8310223taloned
tiled64832943til__ed
tilled74722953til_led
tilter63417693til_ter
tincted1037273tincted
tinted74419533ti_nted
tiptoed1036143tiptoed
toileted936993toileted
tooted74620123_tooted
toted64929483__toted
trilobed1144203trilobed
unilobed1136393unilobed
unlobed10219743unlobed
unloved112310533unloved
unnoted8311363unnoted
upflowed1742893upflowed
uplifted1454423uplifted
uprooted1186393uprooted
uptilted1174683uptil_ted
valeted1139013valeted
violated1237883violated
visited1168773visited
visored1138143visored
vizored2034133vizored
voluted11297943voluted
voted93919143__voted
welted103715823wel_ted
widowed1534843widowed
wilded113714503wil_ded
wiled95231553wil__ed
willed104722453wil_led
willied114611563willied
willowed15156763willowed
wisted104120273wi_sted
wited94727143wi__ted
witted104216813wi_tted
zlote143912943_zlote_

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.406440125.6
2DLD Change Limit1340274767.08018930.4
3Display Results4764760.1862559.1
 (SQL Overall)1786914767.67223291.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.