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

142 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
prompting163719(None) 
promoting1439911promoting
bromating1439162bromating
compting153013602_compting
preempting1745392preempting
primping15338892primp_ing
probating14311182probating
profiting1549982profiting
promising14410972promising
promoing13310462prom_oing
pronating12313762pronating
propping122811672pro_pping
prorating12314282prorating
romping123113032_romp_ing
tromping13319592tromp_ing
adopting1237453ado_pting
arointing1049363arointing
aroynting1344633aroynting
bromizing2346583bromizing
chomping18339883chomp_ing
clomping15329653clomp_ing
coapting133511613_coapting
coempting1636073coempting
competing163712463_competing
comping143518593_comp_ing
computing16309853_computing
coopting133411313_coopting
cramping153411853cramp_ing
cremating14312193cremating
crimping15299783crimp_ing
crimpling1645343crimpling
cropping153210883cro_pping
crumping15319903crump_ing
crumpling1645323crumpling
drooping12268803droop_ing
dropping14309283dro_pping
erupting11218443er_upting
exempting2144223exempting
fronting12310443fro_nting
frosting12311183fro_sting
frowsting1634683frowsting
grommeting1642913grommeting
groping113313103gro_p_ing
grouping12308533group_ing
grouting103410793gro_uting
grumping14266903grump_ing
irrupting1243553irrupting
opting94514403__o_pting
peopling1338353peo_pling
permuting1446553permuting
perorating13313133perorating
phonating1537813phonating
pimping143812123p_imp_ing
plopping12318703plo_pping
plotting113011013plo_tting
plumping15277633plump_ing
pointing112813683p_ointing
pomading1437423p_omading
pooping123615443p_oop_ing
popping113715413p_o_pping
poppling12227323p_oppling
porting103021783p_o_rting
positing11312303p_ositing
posting105622243p_o_sting
potting103720893p_o_tting
pouting103519943p_o_uting
prating103424453pr__ating
preacting142412533preacting
precomputing2153273precomputing
predating13514653predating
premising14412413premising
premixing2157803premixing
prepping12309763pr_epping
priesting1239483priesting
priming123417373prim__ing
primming15268173prim_ming
printing113216083pr_inting
probing123314443pro__bing
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
profaning1537293profaning
profiling1548233profiling
progging132610383pro_gging
projecting22177243projecting
prolapsing1543873prolapsing
prologing1338953prologing
promine112819443prom__ine
promotion1359503promotion
promotions1448773promotions
promotive1648033promotive
prompt12313013prompt___
prompted1536903prompt_ed
prompter1437983prompt_er
prompters1537553prompters
promptest1546063promptest
promptly1743913prompt_ly
prompts1337473prompt__s
promulging1642683promulging
pronging123511843pro_nging
proofing1439313pro_ofing
propine113020213pro_p_ine
propining14310133propining
proponing1439993proponing
proposing1439673proposing
prosecting15189813prosecting
prosing103319383pro__sing
prospecting1845853prospecting
prospering1547173prospering
protecting151910213protecting
protesting131910253protesting
providing1637963providing
proving134214073pro__ving
provoking1935133provoking
prowling1449993pro_wling
pumping144213553p_ump_ing
ramping123316873_ramp_ing
remating112322413_remating
rimpling13219663_rimpling
roasting93012693_roasting
roosting93411453_roosting
rooting83522433_ro_oting
roping94023023_ro_p_ing
rotating92614553_rotating
rotting82919683_ro_tting
rouping103715793_roup_ing
rousting93913273_rousting
routing83821093_ro_uting
rumpling13178763_rumpling
sprouting1236943spro_uting
stomping13309763stomp_ing
tempting1357343_tempting
tramping132711273tramp_ing
trampling1436963trampling
trooping112710273troop_ing
trotting92510913tro_tting
trouping11249503troup_ing
trumpeting1543563trumpeting
trumping13308733trump_ing
uprooting1276903upro_oting
vomiting1437733_vomiting
whomping19285943whomp_ing

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.186960704.3
2DLD Change Limit1486411427.65619415.0
3Display Results1421420.0463087.0
 (SQL Overall)1786911427.88822653.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.