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

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

81 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
prohibiting195393(None) 
prohibition1854262prohibition
prohibitions1953832prohibitions
prohibitive2152822prohibitive
adhibiting1742773_adhibiting
cohabiting1844803_cohabiting
exhibiting2343623_exhibiting
frostbiting1752373frostbiting
inhibiting1645113_inhibiting
prelimiting1645383prelimiting
previsiting1745543previsiting
probating14311193pro__bating
profiting1549983pro__fiting
prohibit1547193prohibit___
prohibited1853473prohibit_ed
prohibitory2152573prohibitory
prohibits1644933prohibit__s
propitiating1755003propitiating
arointing1049364aro_i_nting
brominating1696094brominating
cohobating1845024_cohobating
deorbiting1445154deo_rbiting
eroticizing2375404eroticizing
frostbitings1851264frostbitings
habiting1437534___habiting
inhabiting1644294_inhabiting
nonbiting1247824_no_nbiting
orbiting1138154__o_rbiting
pointing112813684p_o_i_nting
positing11312304p_o__siting
precipitin1655864precipitin_
precipitins1746174precipitins
predicating1749654predicating
predicting1649874predi_cting
preediting1447934pr_eediting
preexciting2343754preexciting
preheating16310724preh_eating
prehiring1548384preh__iring
preinviting1744364preinviting
presifting1638084presi_fting
preuniting1347304pr_euniting
prewriting1647244pr_ewriting
priesting1239484pr__iesting
printing113216084pr__i_nting
prioritizing2453404prioritizing
probing123314444pro__b__ing
probities13312654pro__bities
proclaiming1843874proclaiming
procreating1647694procreating
profiling1548234pro__filing
prohibitionist2162424prohibitionist
prohibitively2662004prohibitively
projecting22177244pro_jecting
prolixities2046364prolixities
prologizing2445234prologizing
promising14410974pro__mising
promoting1439924pro__moting
prompting1637204pro__mpting
pronating12313764pro__nating
propagating1754884propagating
propining14310134pro__pining
prorating12314284pro__rating
prorogating1556064prorogating
proscribing1853904proscribing
prosecting15189814pro_secting
prosecuting1645024prosecuting
proselyting1743904proselyting
prospecting1845854prospecting
prostituting1573954prostituting
prostrating1449394prostrating
protecting151910214pro_tecting
protesting131910254pro_testing
protonating1448594protonating
protracting1646934protracting
providing1637964pro__viding
provisioning1883594provisioning
proximities2255884proximities
rabbiting1445034_r_abbiting
reexhibiting2571694reexhibiting
revisiting1446954_revisiting
soliciting1346814_soliciting

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 Filter1786911488190.436409841.7
2DLD Change Limit148819818.29617938.6
3Display Results81810.0461760.9
 (SQL Overall)178691818.77820356.7
 
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.