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

139 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
profiting154998(None) 
profiling1548231profiling
positing11312302p_ositing
prefiling1549532prefiling
prefiring1559072prefiring
prefixing2246782prefixing
probating14311192probating
profaning1537292profaning
profilings1653562profilings
promising14410972promising
promoting1439922promoting
prompting1637202prompting
pronating12313762pronating
propining14310132propining
prorating12314282prorating
providing1637962providing
arointing1049363arointing
aroynting1344633aroynting
broiling113112013bro_iling
bromating1439183bromating
bromizing2346583bromizing
bruiting11259973br_uiting
crafting143710173craf_ting
crediting1338843crediting
drafting13339413draf_ting
drifting13338733drif_ting
erotizing1949963erotizing
forfeiting1744133forfeiting
fronting12310443fro_nting
frosting12311183fro_sting
frowsting1634683frowsting
fruiting12229063fr_uiting
graffiting1842923graffiting
grafting13319623graf_ting
grifting13299263grif_ting
groining102310633gro_ining
grouting103410793gro_uting
ironizing1947933ironizing
lofting113311313_lof_ting
orbiting1138153or_biting
perorating13313133perorating
peroxiding2144933peroxiding
phonating1537813phonating
plaiting113113513p_laiting
plotting113011013plo_tting
pointing112813683p_ointing
poising103617103p_o_ising
policing13311673p_olicing
porting103021783p_o_rting
posting105622243p_o_sting
potting103720893p_o_tting
pouting103519943p_o_uting
praising113214563pr_aising
prating103424453pr__ating
preacting142412533preacting
precising14413273precising
predating13514653predating
predicting1649873predicting
preediting1447933preediting
prefacing17118743prefacing
prefading16149033prefading
prehiring1548383prehiring
premising14412413premising
premixing2157803premixing
presiding13510903presiding
presifting1638083presifting
preuniting1347303preuniting
prevising15510873prevising
prewiring1547893prewiring
prewriting1647243prewriting
pricing123417343pr__icing
priding113317543pr__iding
priesting1239483priesting
priming123417373pr__iming
printing113216083pr_inting
prising103321453pr__ising
prizing193514683pr__izing
probing123314443pro__bing
probities13312653probities
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
professing16106623professing
proffering1943773proffering
proficient1756243proficient
profit113016273profit___
profited14279973profit_ed
profiteer14274493profiteer
profiteering1852133profiteering
profiter132710203profit_er
profiters14228313profiters
profits122911243profit__s
profitwise1852093profitwise
progging132610383pro_gging
prohibiting1953933prohibiting
projecting22177243projecting
prologing1338953prologing
promoing13310463pro_moing
pronging123511843pro_nging
proofing1439313pro_ofing
proponing1439993proponing
proposing1439673proposing
propping122811673pro_pping
prosecting15189813prosecting
prosing103319383pro__sing
protecting151910213protecting
protesting131910253protesting
proving134214073pro__ving
provoking1935133provoking
prowling1449993pro_wling
pyrolizing2546843pyrolizing
quoiting1836093quo_iting
rafting113815753_raf_ting
reciting113118073_reciting
refiling123116533_refiling
refining122416863_refining
refiring123513923_refiring
refitting132811123_refitting
refixing19329793_refixing
refuting121911903_refuting
resiting93521123_resiting
rifting113515003_rif_ting
roasting93012703_roasting
roiling83220453_ro_iling
roosting93411463_roosting
rooting83522433_ro_oting
rosining92411423_rosining
rotating92614553_rotating
rotting82919683_ro_tting
rousting93913273_rousting
routing83821093_ro_uting
sopiting11310763_sopiting
sprouting1236943spro_uting
toiting83217093_to_iting
trotting92510913tro_tting
uprooting1276903upro_oting
vomiting1437733_vomiting
worriting1345553worriting
writing113713893wr__iting

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 Filter1786911486410.846211218.7
2DLD Change Limit1486411396.46622988.1
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.37524229.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.