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

132 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
profiling154823(None) 
prefiling1549531prefiling
profilings1653561profilings
profiting1549981profiting
broiling113112012bro_iling
prefiring1559072prefiring
prefixing2246782prefixing
profaning1537292profaning
promising14410972promising
propining14310132propining
providing1637962providing
prowling1449992pro_wling
refiling123116532_refiling
roiling83220452_ro_iling
boiling103819673_bo_iling
brailing113514793br_ailing
bromizing2346583bromizing
coffling1736483_coffling
coiling103723453_co_iling
defiling132812463_defiling
drolling103510763dro_lling
drooling102610423dro_oling
erotizing1949963erotizing
filing103823763___filing
foiling113317653_fo_iling
groining102310633gro_ining
groveling1435573groveling
growling1348163gro_wling
ironizing1947933ironizing
misfiling1537223misfiling
moiling103417663_mo_iling
oiling74925313__o_iling
parboiling1545173parboiling
paroling113316213paro__ling
penciling1437413penciling
peopling1338353peo_pling
periling11316863p_eriling
peroxiding2144933peroxiding
piffling1745133p_iffling
piling95025593p___iling
poising103617103p_o_ising
policing13311673p_olicing
poling93526503p_o__ling
polling102920383p_o_lling
pooling103219093p_o_oling
poppling12227323p_oppling
positing11312303p_ositing
praising113214563pr_aising
prattling1246303prattling
prebilling1595413prebilling
preboiling1546403preboiling
precising14413273precising
prefacing17118743prefacing
prefading16149033prefading
prehiring1548383prehiring
premising14412413premising
premixing2157803premixing
presiding13510903presiding
prevailing1656723prevailing
prevising15510873prevising
prewiring1547893prewiring
pricing123417343pr__icing
prickling1836533prickling
priding113317543pr__iding
prilling113413413pr_illing
priming123417373pr__iming
prising103321453pr__ising
prizing193514683pr__izing
probating14311183probating
probing123314443pro__bing
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
professing16106623professing
proffering1943773proffering
proficient1756243proficient
profile123211153profil__e
profiled14338523profil_ed
profiler13287643profil_er
profilers14236293profilers
profiles133211233profil_es
progging132610383pro_gging
proline92321593pro__line
prologing1338953prologing
prolong10319633pro__long
promoing13310463pro_moing
promoting1439913promoting
prompting1637193prompting
promulging1642683promulging
pronating12313763pronating
pronging123511843pro_nging
proofing1439313pro_ofing
propelling1556933propelling
proponing1439993proponing
proposing1439673proposing
propping122811673pro_pping
prorating12314283prorating
prosing103319383pro__sing
proving134214073pro__ving
provoking1935133provoking
purfling1467763purf_ling
pyrolizing2546843pyrolizing
raffling1567063_raffling
railing83325643_r_ailing
refilling13299333_refilling
refilming15256463_refilming
refining122416863_refining
refiring123513923_refiring
refixing19329793_refixing
reoiling93217213_reoiling
resiling93520173_resiling
retiling93319483_retiling
reviling122917213_reviling
riffling1556113_riffling
rifling112815013_rif_ling
riling74227973_r__iling
rockling15259383_rockling
rolling83620413_ro_lling
rootling9269953_rootling
rosining92411423_rosining
roweling122811123_roweling
ruffling1546093_ruffling
soiling83422323_so_iling
spoiling112911553spo_iling
toiling83219023_to_iling
trailing92916093tr_ailing
trifling122411503trif_ling
trolling93212493tro_lling
troubling1234933troubling
troweling1376363troweling
upboiling1444623upbo_iling
upcoiling1444793upco_iling

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.1601116818.8
2DLD Change Limit1486411328.14018260.6
3Display Results1321320.0602200.0
 (SQL Overall)1786911328.36021374.5
 
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.