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 “promptest” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

55 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
promptest154606(None) 
promotes12314122promotes_
prompted1536902prompte_d
prompter1437982prompte_r
prompters1537552prompters
promptness1643302promptness
prompts1337472prompt_s_
protest9317532pro__test
bromates12413143bromates_
crampiest15268613crampiest
crimpiest15237183crimpiest
croupiest1337063croupiest
droopiest1235743droopiest
frumpiest1634543frumpiest
grumpiest1435023grumpiest
plumpest14236353plump_est
politest10312943p_olitest
posttest10410233p_osttest
preppiest1236973preppiest
pretest9517633pr__etest
primates121515933primates_
primmest14226693prim_mest
privatest14196733privatest
probates12414283probates_
proettes10312763proettes_
prominent1349573prominent
promines123018803promines_
promises122916763promises_
promote11313143promote__
promoted13310543promote_d
promoter12311453promote_r
promoters13310093promoters
prompt12313013promp___t
prompting1637203prompting
promptly1743913prompt_ly
pronates10418373pronates_
properest1349663properest
prophesy1844453pro_phesy
prophet14316033pro_phe_t
prophets1539503pro_phets
propjet1839913pro_pje_t
propjets1935493pro_pjets
prorates10418073prorates_
prosiest10416523pro_siest
prospect1447893prosp_ect
protect11313633pro__tect
protests10310493pro__tests
protist9320223pro__tist
proudest1138943pro_udest
prowest12311533pro__west
remotest103310723_remotest
ropiest93317773_ro_piest
roupiest102610293_roupiest
trampiest13227893trampiest
trompes114111623tromp_es_

Search took 7 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.420425454.8
2DLD Change Limit148641556.28323657.6
3Display Results55550.0134230.8
 (SQL Overall)178691556.71626606.8
 
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.