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

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

82 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
ovipositional186246(None) 
oppositional1683842o_ppositional
oviposition1653592oviposition__
ovipositions1753562oviposition_s
appositional1683943_appositional
compositional1974053compositional
depositional1554623_depositional
dispositional1653743dispositional
expositional2153943_expositional
ovipositing1752683ovipositi_n_g
positional1247903___positional
postpositional1862653postpositional
prepositional1755193prepositional
propositional1755243propositional
suppositional1763063suppositional
opposition1445484o_pposition__
oppositions1575124o_pposition_s
ovipositor1551674oviposit_o__r
ovipositors1651574oviposit_o_rs
volitional1345414_v__olitional
acquisitional2461805acquisitional
apparitional1652765_apparitional
apposition1446595_apposition__
appositions1546155_apposition_s
avocational1645185av__ocational
biconditional1862245_biconditional
coitional1148695___co_itional
composition1746795composition__
compositionally2462285compositionally
compositions1846255composition_s
deposition13107835_deposition__
depositions14117685_deposition_s
disposition1446695disposition__
dispositions1546475disposition_s
exposition1947165_exposition__
expositions2046845_exposition_s
imposition1446535_imposition__
impositions1546035_imposition_s
inquisitional2272835inquisitional
intuitional1155295__intuitional
juxtapositional3181035juxtapositional
malposition1553965malposition__
malpositions1653675malposition_s
misposition1555685misposition__
mispositioned1862195mispositioned
mispositions1655305misposition_s
operational1347525o__perational
oppositionist17143815o_ppositionist
optional1047645o__p___tional
orientational1353805orientational
ovational1246855ov____ational
overemotional1861925overemotional
oviposit13375615oviposit_____
oviposited1652155oviposit___ed
oviposits14503735oviposit____s
position10912195___position__
positionally1754925___positionally
positioned1396005___positioned
positions11811505___position_s
postposition1654795postposition__
postpositions1753965postposition_s
preposition15108585preposition__
prepositionally2262515prepositionally
prepositions16108305preposition_s
proportional1655815propo_rtional
proposition1588745proposition__
propositioned1853915propositioned
propositions16108315proposition_s
reimposition1653965reimposition__
reimpositions1753615reimposition_s
repetitional1453725_repetitional
reposition121010145_reposition__
repositioned1554225_repositioned
repositions131110165_reposition_s
supposition1555205supposition__
suppositions1654895supposition_s
transitional1256225_transitional
transpositional17112335transpositional
vibrational1644365_vi_brational
visional1146665_vi__s__ional
vivisectional2162105_vivisectional
vocational1546955_v__ocational

Search took 10 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 Filter1786911247900.453394461.4
2DLD Change Limit124790829.22013534.7
3Display Results82820.0461782.6
 (SQL Overall)178691829.71918385.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.