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

242 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
pivoting143618(None) 
picoting1338881picoting
piloting1139691piloting
devoting1338822devoting
pilotings1234352pilotings
pirating11314512pirating
pitting103618872pi_tting
revoting12312032revoting
rioting82716392ri_oting
riveting12139442riveting
voting103916032__voting
airting83616303ai_rting
aviating12311013aviating
avowing1466603_avowing
bighting15269453bighting
biotin83215833bi_otin_
biotins93114453bi_otins
biting95321823bi__ting
bitting103717293bi_tting
booting103821363_booting
cavorting1536063cavorting
citing94220183ci__ting
coting94629253__coting
coveting141912303coveting
demoting12311423demoting
denoting10311753denoting
dieting93616833di_eting
dighting142510843dighting
dilating102714903dilating
diluting10248983diluting
dinting93520553di_nting
dittoing1036263dittoing
diverting142410333diverting
divesting14298483divesting
dividing1437183dividing
diving113717953div__ing
divining1338413divining
divorcing1644323divorcing
divvying1932773divvying
doting84821913__doting
emoting10313563_emoting
epilating12310963epilating
escoting1158713escoting
evicting1437483evicting
eviting11511373_eviting
evoking1536413_evoking
fagoting1336283fagoting
favoring1596673favoring
fighting162710083fighting
fileting1239303fileting
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
footing115017593_footing
frivoling1644493frivoling
garoting10510703garoting
gavotting1443193gavotting
gifting123810893gi_fting
girting93113333gi_rting
gitting93215703gi_tting
giving114313883giv__ing
highting16259723highting
hilting113316893hi_lting
hinting113919223hi_nting
histing113720373hi_sting
hitting113017273hi_tting
hiving134115523hiv__ing
hooting113919883_hooting
ingoting1039863ingoting
inviting1239733inviting
invoking1635653invoking
ironing82414013_ironing
jilting153211743ji_lting
jiving173711603jiv__ing
kilting123213853ki_lting
kiting114117093ki__ting
kitting123214443ki_tting
lichting14268513lichting
lifting113313273li_fting
ligating102212283ligating
lighting132811833lighting
lilting83515383li_lting
limiting1138813limiting
linting83820983li_nting
listing84020593li_sting
livening12248153livening
livering122012383livering
living104318323liv__ing
looting83019643_looting
miaouing1134893miaouing
miaowing1434593miaowing
milting103619123mi_lting
minoring11311473minoring
minting103020813mi_nting
minuting1139723minuting
misting103623383mi_sting
mooting103019363_mooting
nicotin948383nicotin_
nicotine1058473nicotine
nicotins1058173nicotins
nidating1039783nidating
nonvoting1346903nonvoting
noting74120153__noting
opiating11410093opi_ating
outvoting1336823outvoting
painting113614423painting
panting104025423p_anting
paroling113316213paroling
parroting1239153parroting
parting103527383p_arting
pasting103826553p_asting
patting103722343p_atting
paving124519743pav__ing
pavonine1346663pavonine
pelting102917273p_elting
petting103720953p_etting
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
piling95025593pi__ling
pilling103722563pi_lling
pillowing1545493pillowing
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
pivot106523873pivot___
pivotal1245433pivot_al
pivoted1336513pivot_ed
pivotman1542053pivotman
pivotmen1542653pivotmen
pivots115111903pivot__s
plaiting113113513plaiting
planting113515383planting
plating103823073p_lating
platting114813033platting
pleating112916053pleating
plighting1635563plighting
plotting113011013plotting
plotzing20276153p_lotzing
plowing133111723p_lowing
ploying132811573p_loying
pointing112813683pointing
poisoning1245903poisoning
poking133819303p__oking
poling93526503p__oling
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
printing113216083printing
prisoning1237643prisoning
probing123314443p_robing
promoting1439913promoting
proofing1439313proofing
prosing103319383p_rosing
proving134214073p_roving
provoking1935133provoking
punting103318443p_unting
pupating1337683pupating
putting103218573p_utting
quoting17310043_quoting
revoking1637803revoking
revolting1339633revolting
rifting113515003ri_fting
righting132610853righting
riposting1236063riposting
rivaling1239913rivaling
rivetting13256413rivetting
riving104521423riv__ing
rooting83522433_rooting
savoring1269483savoring
scooting113012643scooting
shooting122812863shooting
sifting113014593si_fting
sighting133110863sighting
siloing83215503silo_ing
silting83320483si_lting
siting74126623si__ting
sitting83519633si_tting
snooting92813203snooting
sooting82820963_sooting
spiriting1238413spiriting
spirting112913633spi_rting
spiting103917623spi__ting
spitting113012323spi_tting
tilting83417103ti_lting
tincting1148883tincting
tinting84620603ti_nting
tooting83019423_tooting
toting74123793__toting
uprooting1276903uprooting
visiting1238393visiting
visoring1238373visoring
vizoring2134573vizoring
voling103918023__voling
vowing133715273__vowing
widowing1635183widowing
wilting113515913wi_lting
wisting113519743wi_sting
witing103522823wi__ting
witting113417063wi_tting
wiving133316603wiv__ing

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.1561145455.1
2DLD Change Limit1461622429.25015801.3
3Display Results2422420.1102200.0
 (SQL Overall)1786912429.51618778.0
 
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.