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

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

108 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
transpositional1711233(None) 
transposition1554182transposition__
transpositions1663672transposition_s
transitional1256223tran___sitional
transpirational1773103transpirational
appositional1683944__a_ppositional
dispositional1653744__dispositional
prepositional1755194pr__epositional
propositional1755244pr__opositional
transactional1553424trans__actional
transcriptional1992244transcriptional
transductional1782514trans_ductional
transfusional1662414transfus__ional
translational1354744trans__lational
transnational1353914trans__national
compositional1974055__compositional
depositional1554625___depositional
expositional2153945___expositional
juxtapositional3181035juxtapositional
oppositional1683845___oppositional
ovipositional1862465__ovipositional
positional1247905_____positional
postpositional1862655_postpositional
suppositional1763065__suppositional
traditional1255395tra____ditional
transition1049705tran___sition__
transitionally1763125tran___sitionally
transitions1148925tran___sition_s
translocation1554685translocation__
translocations1664235translocation_s
transpersonal1562535transp__ersonal
transpiration1555425transpiration__
transpirations1654725transpiration_s
transpontine1465135transpo_nti_n_e
transportation1663295transportation__
transportations1762905transportation_s
transporting1555785transpo_rti_n_g
transposing1455455transpos__i_n_g
transposon1254475transpos___on__
transposons1354585transpos___on_s
acquisitional2461806__acquisitional
apparitional1652766__a_pparitional
apposition1446596__a_pposition__
appositions1546156__a_pposition_s
aspirational1455006__a_spirational
associational1552936__a_ssociational
consociational1853556_cons_ociational
conspirational1853966_conspirational
disposition1446696__disposition__
dispositions1546476__disposition_s
indisposition1662496indisposition__
indispositions1782186indisposition_s
inquisitional2272836__inquisitional
inspirational1554416__inspirational
malposition1553966_ma_lposition__
malpositions1653676_ma_lposition_s
misposition1555686__misposition__
mispositioned1862196__mispositioned
mispositions1655306__misposition_s
nonsensational1463276_nonsensational
predisposition1992206predisposition__
predispositions2092086predisposition_s
preposition15108586pr__eposition__
prepositionally2262516pr__epositionally
prepositions16108306pr__eposition_s
proportional1655816pr__opo_rtional
proposition1588746pr__oposition__
propositioned1853916pr__opositioned
propositions16108316pr__oposition_s
redisposition16103126redisposition__
redispositions17102886redisposition_s
reimposition1653966_reimposition__
reimpositions1753616_reimposition_s
repetitional1453726_r__epetitional
reposition121010146_r__eposition__
repositioned1554226_r__epositioned
repositions131110166_r__eposition_s
tractional1248056tra_____ctional
transaction1346306trans__action__
transactions1445886trans__action_s
transcription1764076transcription__
transcriptions1863636transcription_s
transduction1584456trans_duction__
transductions1664296trans_duction_s
transection1357376trans__ection__
transections1446766trans__ection_s
transfection1765396trans_fection__
transfections1854856trans_fection_s
transfixion2154206trans__fixion__
transfixions2253936trans__fixion_s
transformation1963076transformation__
transformations2062826transformation_s
transfusion1454236transfus__ion__
transfusions1553936transfus__ion_s
transiting11410776tran___siti_n_g
translation1149486trans__lation__
translations1258376trans__lation_s
translocating1654286translocati_n_g
transmission1454596transmis_sion__
transmissions1554126transmis_sion_s
transmittal1354006trans__mit__tal
transmutation1554406transmutation__
transmutations1653806transmutation_s
transpiring1446876transp__iri_n_g
transplanting1663966transplanti_n_g
transudation1355326trans_udation__
transudations1454836trans_udation_s
unsensational1353666__unsensational

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 Filter178691950240.373479064.3
2DLD Change Limit950241088.17311626.6
3Display Results1081080.0761421.1
 (SQL Overall)1786911088.62220725.0
 
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.