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 “promising” 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
promising1441097(None) 
premising14412411premising
atomising1247992atomising
bromizing2346582bromizing
poising103617102p_o_ising
praising113214562pr_aising
precising14413272precising
premixing2157802premixing
prevising15510872prevising
prising103321452pr__ising
profiling1548232profiling
profiting1549982profiting
promisingly1953002promisingly
promoing13310462prom_oing
promoting1439922promoting
prompting1637202prompting
propining14310132propining
proposing1439672proposing
prosing103319382pro__sing
providing1637962providing
remising112516452_remising
unpromising1663622unpromising
agonising1146573agonising
aphorising1645743aphorising
arising83619973ar__ising
arousing93811803aro_using
atomizing2148513atomizing
azotising1945293azotising
braising113014563br_aising
broiling113112013bro_iling
bromating1439173bromating
browsing14319353bro_wsing
bruising11279143br_uising
chromizing2746073chromizing
compromising2152923compromising
creolising1345993creolising
crossing112612683cro_ssing
cruising112610153cr_uising
demising122012523_demising
drowsing13287773dro_wsing
ebonising1245933ebonising
epitomising1653403epitomising
erotizing1949963erotizing
groining102310633gro_ining
grossing103111063gro_ssing
grousing103410453gro_using
hoising113414413_ho_ising
idolising1145893idolising
improvising1943843improvising
iodising1037563_iodising
ionising9310223_ionising
irising83614423ir__ising
ironizing1947933ironizing
itemising1245883itemising
lionising1046463lionising
mortising1238693mortising
noising83615173_no_ising
optimising1544493optimising
outpromising1752423outpromising
ozonising1944333ozonising
patronising1465243patronising
peising103416763p__eising
peroxiding2144933peroxiding
poetising1238713poetising
policing13311673p_olicing
polishing1536923p_olishing
pomading1437423p_omading
porpoising1545833porpoising
posing93922643p_o__sing
positing11312303p_ositing
practising1586363practising
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prehiring1548383prehiring
premiering1547243premiering
prerinsing1347643prerinsing
presiding13510903presiding
pressing112516443pr_essing
prewiring1547893prewiring
pricing123417343pr__icing
priding113317543pr__iding
priming123417373pr__iming
primming15268173prim_ming
primping15338893prim_ping
prissing113011453pr_issing
prizing193514683pr__izing
probating14311193probating
probing123314443pro__bing
processing15108183processing
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
profaning1537293profaning
professing16106623professing
profilings1653563profilings
progging132610383pro_gging
prognosing1444423prognosing
prolapsing1543873prolapsing
prologing1338953prologing
promine112819443prom__ine
prominent1349573prominent
promise113415843promis__e
promised133010873promis_ed
promisee122711333promis_ee
promisees13246863promisees
promiser122510673promis_er
promisers13268203promisers
promises122916763promis_es
promisor12266183promis_or
promisors13236363promisors
promulging1642683promulging
pronating12313763pronating
pronging123511843pro_nging
proofing1439313pro_ofing
proponing1439993proponing
propping122811673pro_pping
prorating12314283prorating
protesting131910253protesting
proving134214073pro__ving
provision1447633provision
provisions1547213provisions
provoking1935133provoking
prowling1449993pro_wling
pumicing1535843p_umicing
pyramiding1943533pyramiding
pyrolizing2546843pyrolizing
raising83220533_r_aising
remixing182810333_remixing
rerising93017783_rerising
revising122714403_revising
rising74025883_r__ising
roiling83220453_ro_iling
romanising1346583_romanising
romping123113033_rom_ping
roosing84018133_ro_osing
rosing73925593_ro__sing
rosining92411423_rosining
rousing83920553_ro_using
surmising1247683surmising
tromping13319603trom_ping
upraising1237263upr_aising
uprising1138953upr__ising
uprousing1235623upro_using
vomiting1437733_vomiting

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.406440125.6
2DLD Change Limit1486411457.48319863.8
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.95222471.2
 
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.