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

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

121 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
transpositional17112331transpositional_
transposition1554183transposition___
transpositions1663673transposition__s
transitional1256224tran___sitional_
transpirational1773104transpirational_
appositional1683945__a_ppositional_
dispositional1653745__dispositional_
prepositional1755195pr__epositional_
propositional1755245pr__opositional_
transactional1553425trans__actional_
transcriptional1992245transcriptional_
transductional1782515trans_ductional_
transfusional1662415transfus__ional_
transitionally1763125tran___sitionally
translational1354745trans__lational_
transnational1353915trans__national_
compositional1974056__compositional_
depositional1554626___depositional_
expositional2153946___expositional_
juxtapositional3181036juxtapositional_
oppositional1683846___oppositional_
ovipositional1862466__ovipositional_
positional1247906_____positional_
postpositional1862656_postpositional_
prepositionally2262516pr__epositionally
suppositional1763066__suppositional_
traditional1255396tra____ditional_
transition1049706tran___sition___
transitions1148926tran___sition__s
translocation1554686translocation___
translocations1664236translocation__s
transpersonal1562536transp__ersonal_
transpiration1555426transpiration___
transpirations1654726transpiration__s
transpontine1465136transpo_nti_n__e
transportation1663296transportation___
transportations1762906transportation__s
transporting1555786transpo_rti_n__g
transposing1455456transpos__i_n__g
transposon1254476transpos___on___
transposons1354586transpos___on__s
acquisitional2461807__acquisitional_
apparitional1652767__a_pparitional_
apposition1446597__a_pposition___
appositions1546157__a_pposition__s
aspirational1455007__a_spirational_
associational1552937__a_ssociational_
compositionally2462287__compositionally
consociational1853557_cons_ociational_
conspirational1853967_conspirational_
disposition1446687__disposition___
dispositions1546477__disposition__s
indisposition1662497indisposition___
indispositions1782187indisposition__s
inquisitional2272837__inquisitional_
inspirational1554417__inspirational_
malposition1553967_ma_lposition___
malpositions1653677_ma_lposition__s
misposition1555687__misposition___
mispositioned1862197__misposition_ed
mispositioning1961377__mispositioning
mispositions1655307__misposition__s
nonsensational1463277_nonsensational_
positionally1754927_____positionally
predisposition1992207predisposition___
predispositions2092087predisposition__s
preposition15108587pr__eposition___
prepositions16108307pr__eposition__s
proportional1655817pr__opo_rtional_
proportionals1764027pr__opo_rtionals
proposition1588747pr__oposition___
propositioned1853917pr__oposition_ed
propositioning1972797pr__opositioning
propositions16108317pr__oposition__s
redisposition16103127redisposition___
redispositions17102877redisposition__s
reimposition1653967_reimposition___
reimpositions1753617_reimposition__s
repetitional1453727_r__epetitional_
reposition121010147_r__eposition___
repositioned1554227_r__eposition_ed
repositioning1653677_r__epositioning
repositions131110167_r__eposition__s
tractional1248057tra_____ctional_
traditionally1753807tra____ditionally
traditionary1663157tra____ditionary
transaction1346307trans__action___
transactions1445887trans__action__s
transcription1764077transcription___
transcriptions1863637transcription__s
transduction1584457trans_duction___
transductions1664297trans_duction__s
transection1357377trans__ection___
transections1446767trans__ection__s
transfection1765397trans_fection___
transfections1854857trans_fection__s
transfixion2154207trans__fixion___
transfixions2253937trans__fixion__s
transformation1963077transformation___
transformations2062827transformation__s
transfusion1454237transfus__ion___
transfusions1553937transfus__ion__s
transiting11410777tran___siti_n__g
transitively1853957tran___siti_vely
transitorily1554057tran___sit_orily
translation1149487trans__lation___
translations1258377trans__lation__s
translocating1654287translocati_n__g
transmission1454597transmis_sion___
transmissions1554127transmis_sion__s
transmittal1354007trans__mit__tal_
transmittals1453457trans__mit__tals
transmutation1554407transmutation___
transmutations1653807transmutation__s
transpiring1446877transp__iri_n__g
transplanting1663967transplanti_n__g
transportable1762647transpo_rt__able
transposable1652747transpos____able
transudation1355327trans_udation___
transudations1454837trans_udation__s
unsensational1353667__unsensational_

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 Filter178691950240.360496363.9
2DLD Change Limit950241218.67310956.3
3Display Results1211210.0931301.1
 (SQL Overall)1786911219.12619580.4
 
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.