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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
dispositional165374(None) 
depositional1554622d_epositional
disposition1446692disposition__
dispositions1546472disposition_s
appositional1683943_appositional
compositional1974053compositional
dispensational1762503dispensational
distortional1353493disto_rtional
expositional2153943_expositional
misposition1555683misposition__
mispositioned1862193mispositioned
mispositions1655303misposition_s
oppositional1683843_oppositional
ovipositional1862463ovipositional
positional1247903___positional
postpositional1862653postpositional
prepositional1755193prepositional
propositional1755243propositional
suppositional1763063suppositional
deposition13107834d_eposition__
depositions14117684d_eposition_s
dispositive1754044dispositi__ve
disproportional2071924disproportional
imposition1446534_imposition__
impositions1546034_imposition_s
indisposition1662494indisposition__
indispositions1782184indisposition_s
mispositioning1961374mispositioning
redisposition16103124redisposition__
redispositions17102884redisposition_s
transpositional17112334transpositional
acquisitional2461805acquisitional
apparitional1652765_apparitional
apposition1446595_apposition__
appositions1546155_apposition_s
aspirational1455005_aspirational
associational1552935_associational
biconditional1862245biconditional
bisectional1554645bis__ectional
coitional1148695___co_itional
composition1746795composition__
compositionally2462285compositionally
compositions1846255composition_s
definitional1653035d_efinitional
depositing1446935d_epositi_n_g
despoliation1546715despoliation__
despoliations1646395despoliation_s
devotional1444675d_evo__tional
diapositive1752795diapositi__ve
diapositives1852365diapositi_ves
dictional1268615di____ctional
diffusional1852245diffus__ional
difunctional18123375di_functional
digressional1453175digres_sional
dilatational1352775di_latational
dimensional1453055dimens__ional
directional1445445di__rectional
dislocation14147505dislocation__
dislocations15136985dislocation_s
dispassion1344325dispas_sion__
dispassionate1662175dispas_sionate
dispassions1453885dispas_sion_s
dispensation1555605dispensation__
dispensations1655485dispensation_s
dispiriting1545945dispiriti_n_g
displosion13184495displos__ion__
displosions14203835displos__ion_s
disporting1439825dispo_rti_n_g
disposal1147025dispos_____al
disposing1339935dispos__i_n_g
disputation14116745disputation__
disputations15106175disputation_s
disquisition2253345disquisition__
disquisitions2353245disquisition_s
dissertational1562575dissertational
dissociation1556645dissociation__
dissociations1656015dissociation_s
dissolution12145025dissolution__
dissolutions13144925dissolution_s
distortion1146705disto_rtion__
distortions1246625disto_rtion_s
distributional1762965distributional
divisional1453955di___visional
dysfunctional2261805dysfunctional
exposition1947165_exposition__
expositions2046845_exposition_s
fissional1245125fis__s__ional
imbibitional1861705_imbibitional
impolitical1753335_impoliti_cal
innovational1553835_innovational
inquisitional2272835inquisitional
inspirational1554415inspirational
intonational1256005_intonational
intuitional1155295_i_ntuitional
invocational1754415_invocational
involutional1553575_involutional
irrotational1254025_irrotational
juxtapositional3181035juxtapositional
malposition1553965malposition__
malpositions1653675malposition_s
missional1146065mis__s__ional
opposition1445485_opposition__
oppositions1575125_opposition_s
oviposition1653595oviposition__
ovipositions1753565oviposition_s
position10912195___position__
positionally1754925___positionally
positioned1396005___positioned
positions11811505___position_s
postposition1654795postposition__
postpositions1753965postposition_s
predisposition1992205predisposition__
predispositions2092085predisposition_s
preposition15108585preposition__
prepositionally2262515prepositionally
prepositions16108305preposition_s
proportional1655815propo_rtional
proposition1588745proposition__
propositioned1853915propositioned
propositions16108315proposition_s
reimposition1653965reimposition__
reimpositions1753615reimposition_s
repetitional1453725_repetitional
reposition121010145_reposition__
repositioned1554225_repositioned
repositions131110165_reposition_s
sensational1146385__sensational
speciational1654315__speciational
supposition1555205supposition__
suppositions1654895supposition_s
transitional1256225_transitional
unsensational1353665unsensational
volitional1345415___volitional

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.420425454.8
2DLD Change Limit1247901339.03313814.9
3Display Results1331330.0931430.1
 (SQL Overall)1786911339.54618718.9
 
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.