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

376 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
piloting113969(None) 
picoting1338881picoting
pilotings1234351pilotings
pivoting1436181pivoting
dilating102714912dilating
diluting10248982diluting
epilating12310972epilating
fileting1239302fileting
hilting113316892hil_ting
jilting153211742jil_ting
kilting123213852kil_ting
lilting83515382lil_ting
milting103619122mil_ting
pelting102917272pel_ting
piling95025592pil__ing
pilling103722562pil_ling
pillowing1545492pillowing
pirating11314512pirating
pitting103618872pi_tting
plating103823072p_lating
plotting113011012p_lotting
plotzing20276152p_lotzing
plowing133111722p_lowing
ploying132811572p_loying
rioting82716392ri_oting
siloing83215502silo_ing
silting83320482sil_ting
tilting83417102til_ting
wilting113515912wil_ting
ablating11312003ablating
ailing74331013ail__ing
airting83616303ai_rting
allotting1046503allotting
allowing12369093allowing
alloying12339143alloying
balloting1238393balloting
belting104119133bel_ting
bighting15269453bighting
bilging114212683bil_ging
bilking144413553bil_king
billeting1236643billeting
billing103823853bil_ling
billowing1545873billowing
biltong1034683bil_tong
biotin83215833bi_otin_
biotins93114453bi_otins
biting95321823bi__ting
bitting103717293bi_tting
bloating113512813_bloating
blotting113910433_blotting
blowing133813053_blowing
bolting104416763bol_ting
booting103821363_booting
citing94220183ci__ting
cloning103215473_cloning
closing103114843_closing
clothing14278783_clothing
clotting113110643_clotting
clouting113011683_clouting
cloying133511753_cloying
coloring11414843coloring
coting94629253__coting
delating103119603delating
deleting103314423deleting
demoting12311423demoting
denoting10311753denoting
depilating1439193depilating
devoting1338823devoting
dialoging1246313dialoging
dieting93616833di_eting
dighting142510843dighting
dinting93520553di_nting
dittoing1036263dittoing
doting84821913__doting
elating83423083_elating
eloping103512833_eloping
eluting84115293_eluting
emoting10313563_emoting
epiloguing1452373epiloguing
escoting1158713escoting
fagoting1336283fagoting
felting113515213fel_ting
fighting162710083fighting
filching1736113filching
filiating1339253filiating
filing103823763fil__ing
filleting1335853filleting
filling113520803fil_ling
filming133210353fil_ming
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
flinting123412343flinting
flirting12319013flirting
fliting113514613_fliting
flitting123010883flitting
floating123111883_floating
flouting122610473_flouting
flowing143411763_flowing
fluting113815093_fluting
flyting14378553_flyting
footing115017593_footing
galoping1258023galoping
garoting10510703garoting
gelating103015733gelating
gifting123810893gi_fting
gilding103813003gil_ding
gilling93520383gil_ling
gillying13306813gillying
gimleting1343863gimleting
girting93113333gi_rting
gitting93215703gi_tting
glinting103210053glinting
gloating102611463_gloating
globing113210003_globing
glouting10379693_glouting
gloving12308443_gloving
glowing123211793_glowing
glozing18338893_glozing
haloing113814133halo_ing
halting114419073hal_ting
highting16259723highting
hilding123713533hil_ding
hilling113821773hil_ling
hilloaing1375433hilloaing
hilloing12158303hilloing
hinting113919223hi_nting
histing113720373hi_sting
hitting113017273hi_tting
hooting113919883_hooting
ingoting1039863ingoting
ironing82414013_ironing
jolting153410913jol_ting
killing123118723kil_ling
kilning12289023kil_ning
kiloton1196313kiloton_
kilotons1286313kilotons
kiltings13327083kil_tings
kiting114117093ki__ting
kitting123214443ki_tting
lichting14268513lichting
lifting113313273li_fting
ligating102212283ligating
lighting132811833lighting
limiting1138813limiting
linting83820983li_nting
listing84020593li_sting
lofting113311313__lofting
looing73621043__looing
looting83019643_looting
loping93921413__loping
losing74022873__losing
lotting82917753__lotting
louting83719383__louting
loving104416723__loving
lowing104623273__lowing
loxing143615273__loxing
luting75221753__luting
malting103219083mal_ting
melting103317753mel_ting
miaouing1134893miaouing
miaowing1434593miaowing
milding113615453mil_ding
milking143712763mil_king
milling103223683mil_ling
minoring11311473minoring
minting103020813mi_nting
minuting1139723minuting
misting103623383mi_sting
molting103517173mol_ting
mooting103019363_mooting
mulcting13246983mulcting
nicotin948383nicotin_
nicotine1058473nicotine
nicotins1058173nicotins
nidating1039783nidating
nilling83619563nil_ling
noting74120153__noting
oiling74925313oil__ing
opiating11410093opi_ating
oppilating1544863oppilating
painting113614423painting
palatine10316073palatine
paling93530133pal__ing
palleting1238743palleting
palling104024483pal_ling
palming123914013pal_ming
palomino1246193palomino
palpating1438543palpating
palping124112873pal_ping
palsying1436233palsying
panting104025423p_anting
paroling113316213paroling
parroting1239153parroting
parting103527383p_arting
pasting103826553p_asting
patting103722343p_atting
pelleting1237953pelleting
peloton938743peloton_
pelotons1038913pelotons
petting103720953p_etting
philtring1544173philtring
phoning13312053p_honing
photoing1439073p_hotoing
piaffing1733923piaffing
picketing1835683picketing
picking163418333pi_cking
pickling17239203pickling
picolin11310883picolin_
picoline12310853picoline
picolins1239853picolins
piddling13208953piddling
piecing12410453pi_ecing
pieing93917653pi__eing
piercing1346663piercing
piffling1745133piffling
pigging123614673pi_gging
piing85218833pi___ing
piking133719643pi__king
pilfering1536393pilfering
pilings103313613pil__ings
pillaging1345573pillaging
pillaring1237653pillaring
pillorying1642793pillorying
pilosity1366333pilosity
pilot77435063pilot___
pilotage1145373pilotage
piloted10310323pilot_ed
pilotfish1742603pilotfish
pilots84018873pilot__s
pimping143812123pi_mping
pinching163711053pinching
pindling122110983pindling
pinging113419553pi_nging
pining93726533pi__ning
pinioning1246863pinioning
pinking143918943pi_nking
pinning103417853pi_nning
pipetting1435513pipetting
piping114017453pi__ping
pipping113414743pi_pping
piquing1935873pi_quing
pishing134314373pi_shing
pissing103914803pi_ssing
pistoling1268493pistoling
pitching163411113pitching
pithing134014053pi_thing
pittings11349123pi_ttings
pitying132910243pi_tying
placing123815283p_lacing
plaiting113113513plaiting
planing103418253p_laning
planting113515383planting
platina94413643p_latina
platings113611363p_latings
platting114813033platting
playing133816093p_laying
pleating112916053pleating
plighting1635563plighting
plinking153611243plinking
plodding13166343p_lodding
plonking15358563p_lonking
plopping12318703p_lopping
plotline1037643p_lotline
pluming123412043p_luming
plying124312083p_l_ying
pointing112813683pointing
poisoning1245903poisoning
poking133819303p__oking
policing13311673policing
poling93526503p__oling
polkaing1534633polkaing
polling102920383pol_ling
polluting1235703polluting
poohing133112323p_oohing
pooing93820683p__ooing
pooling103219093p_ooling
pooping123615443p_ooping
poring94227273p__oring
porting103021783p_orting
posing93922643p__osing
positing11312303positing
posting105622243p_osting
potting103720893p_otting
pouting103519943p_outing
poxing163714943p__oxing
prating103424453p_rating
priesting1239483priesting
prilling113413413pril_ling
printing113216083printing
prisoning1237643prisoning
probing123314443p_robing
prologing1338953prologing
promoting1439923promoting
proofing1439313proofing
prosing103319383p_rosing
proving134214073p_roving
psilocin1243393psilocin_
psilocins1343563psilocins
psilotic1245773psiloti_c
puling93621403pul__ing
pulling103821073pul_ling
pulping123612323pul_ping
pulsating1236343pulsating
pulsing103712863pul_sing
punting103318443p_unting
pupating1337683pupating
putting103218573p_utting
quilting18218713quil_ting
quoting17310043_quoting
relating92725443relating
revoting12312033revoting
rifting113515003ri_fting
righting132610853righting
riling74227973ril__ing
rilling84023623ril_ling
riposting1236063riposting
riveting12139443riveting
rooting83522433_rooting
salting84120793sal_ting
saluting9310553saluting
scooting113012643scooting
shooting122812863shooting
sifting113014593si_fting
sighting133110863sighting
silking123715593sil_king
siting74126623si__ting
sitting83519633si_tting
slating83724653_slating
slitting93012583slitting
sloping104114073_sloping
slotting92612613_slotting
slowing112814743_slowing
snooting92813203snooting
solating9315593solating
soloing82813803solo_ing
sooting82820963_sooting
spiling102919703spil__ing
spilling113113943spil_ling
spiriting1238413spiriting
spirting112913633spi_rting
spiting103917623spi__ting
spitting113012323spi_tting
splinting1238193splinting
splitting1236563splitting
stilting93312403stil_ting
tailoring1036403tailoring
tiling73426553til__ing
tilling83522783til_ling
tincting1148883tincting
tinting84620603ti_nting
toileting1036263toileting
tooting83019423_tooting
toting74123793__toting
unloving1277483unloving
upflowing1842933upflowing
uplifting1534963uplifting
uprooting1276903uprooting
uptilting1234713uptil_ting
valeting1238853valeting
violating1337443violating
visiting1238393visiting
visoring1238373visoring
vizoring2134573vizoring
voting103916033__voting
welting113615313wel_ting
widowing1635183widowing
wilding123814293wil_ding
wildling13248083wildling
wiling103024293wil__ing
willing113821613wil_ling
willowing1645323willowing
willying15306713willying
wisting113519743wi_sting
witing103522823wi__ting
witting113417063wi_tting

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.423422437.4
2DLD Change Limit1461623766.81321453.4
3Display Results3763760.1562410.3
 (SQL Overall)1786913767.39224173.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.