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

145 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
propining1431013(None) 
proponing1439991proponing
groining102310632gro_ining
opining10311742__opining
preopening1546242preopening
profaning1537292profaning
profiling1548232profiling
profiting1549982profiting
promising14410972promising
propending1646142propending
proposing1439672proposing
propping122811672prop_ping
providing1637962providing
repining114116592_repining
rosining92411422_rosining
aproning11311793apro__ning
arointing1049363aro_inting
braining113414683br_aining
brining103216473br__ining
broiling113112013bro_iling
bromizing2346583bromizing
browning14299643bro_wning
coining103920543_co_ining
crooning113112113cro_oning
cropping153210883crop_ping
crowning143510033cro_wning
draining103312673dr_aining
droning93013723dro__ning
dropping14309283drop_ping
drowning13298363dro_wning
eloining9310443elo_ining
erotizing1949963erotizing
foining113013453_fo_ining
frowning15307833fro_wning
graining102813183gr_aining
groaning102410283gro_aning
groping113313103grop__ing
ironing82414013iro__ning
ironizing1947933ironizing
joining153011483_jo_ining
opening1039923__opening
ordaining1145753ordaining
paining103920243p__aining
patining11312303p_atining
peining104619153p__eining
peopling1338353peop_ling
peroxiding2144933peroxiding
perspiring1544853perspiring
pertaining1347993pertaining
phoning13312053pho__ning
pining93726533___pining
plaining113911553p_laining
plopping12318703plop_ping
poinding122510003p_o_inding
pointing112813683p_o_inting
poising103617103p_o_ising
policing13311673p_olicing
pooping123615443poop__ing
popping113715413p_op_ping
poppling12227323p_oppling
porpoising1545833porpoising
portioning1347193portioning
positing11312303p_ositing
praising113214563pr_aising
prawning1446963pr_awning
prebinding1696163prebinding
precising14413273precising
preening113115843pr_eening
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prehiring1548383prehiring
premising14412413premising
premixing2157803premixing
preparing14311643preparing
prepaving1787233prepaving
prepaying1747973prepaying
prepping12309763prep_ping
prepricing1746733prepricing
preprinting1647413preprinting
prerinsing1347643prerinsing
presiding13510903presiding
prevising15510873prevising
prewiring1547893prewiring
pricing123417343pr__icing
priding113317543pr__iding
priming123417373pr__iming
prinking153212453pr__inking
printing113216083pr__inting
prising103321453pr__ising
prisoning1237643prisoning
prizing193514683pr__izing
probating14311193probating
probing123314443pro__bing
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
profilings1653563profilings
progging132610383pro_gging
prologing1338953prologing
prolonging1444803prolonging
prominent1349573prominent
promoing13310463pro_moing
promoting1439923promoting
prompting1637203prompting
pronating12313763pronating
pronging123511843pro_nging
proofing1439313pro_ofing
propelling1556933propelling
propine113020213prop__ine
propined133111503propin_ed
propines122618933propin_es
proponent1349443proponent
propounding1744053propounding
prorating12314283prorating
prosing103319383pro__sing
prospering1547173prospering
protending1446813protending
proving134214073pro__ving
provoking1935133provoking
prowling1449993pro_wling
pruning10311733pr__uning
purloining1343973purloining
pyrolizing2546843pyrolizing
quoining1835893quo_ining
raining83922693_r_aining
ravining12269693_ravining
refining122416863_refining
reining84425323_r_eining
relining93218743_relining
reopening1248823reopening
repinning12258973_repinning
resining92919553_resining
ripening1138573_ripening
roiling83220453_ro_iling
roping94023023_rop__ing
ruining83514883_r_uining
sopiting11310763_sopiting
spraining1248153spr_aining
training93015863tr_aining
trephining1644933trephining
trining82919213tr__ining
trophying1844713trophying
troponin1047943troponin_
troponins1147203troponins

Search took 9 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 Filter1786911486410.403443402.0
2DLD Change Limit1486411457.70619289.0
3Display Results1451450.0602416.7
 (SQL Overall)1786911458.16921874.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.