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 “transpositions” 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.

98 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
transpositions166367(None) 
transposition1554181transposition_
transpositional17112332transpositional
transitions1148923tran___sitions
translocations1664233translocations
transpirations1654723transpirations
transportations1762903transportations
transposons1354583transpos___ons
appositions1546154__a_ppositions
dispositions1546474__dispositions
indispositions1782184indispositions
malpositions1653674_ma_lpositions
mispositions1655304__mispositions
predispositions2092084predispositions
prepositions16108304pr__epositions
propositions16108314pr__opositions
redispositions17102874redispositions
reimpositions1753614_reimpositions
repositions131110164_r__epositions
transactions1445884trans__actions
transcriptions1863634transcriptions
transductions1664294trans_ductions
transections1446764trans__ections
transfections1854854trans_fections
transfixions2253934trans__fixions
transformations2062824transformations
transfusions1553934transfus__ions
transition1049704tran___sition_
translations1258374trans__lations
translocation1554684translocation_
transmissions1554124transmis_sions
transmutations1653804transmutations
transpiration1555424transpiration_
transpontine1465134transpo_nti_ne
transportation1663294transportation_
transporting1555784transpo_rti_ng
transposing1455454transpos__i_ng
transposon1254474transpos___on_
transudations1454834trans_udations
apposition1446595__a_pposition_
compositions1846255__compositions
contrapositions1992425contra__positions
decompositions2152815decompositions
depositions14117685___depositions
disposition1446685__disposition_
expositions2046845___expositions
grandiosities1552645grandiositi_es
impositions1546035___impositions
indisposition1662495indisposition_
interpositions1685125interpositions
juxtapositions30161585juxtapositions
malposition1553965_ma_lposition_
misposition1555685__misposition_
nondepositions17112555nondepositions
oppositions1575125___oppositions
ovipositions1753565__ovipositions
positions11811505_____positions
postpositions1753965_postpositions
predisposition1992205predisposition_
preposition15108585pr__eposition_
presuppositions1861585presuppositions
proposition1588745pr__oposition_
recompositions2053175recompositions
redisposition16103125redisposition_
reimposition1653965_reimposition_
reposition121010145_r__eposition_
superpositions18145265superpositions
suppositions1654895__suppositions
traditions1147195tra____ditions
transaction1346305trans__action_
transaminations17113425transaminations
transcription1764075transcription_
transduction1584455trans_duction_
transection1357375trans__ection_
transfection1765395trans_fection_
transfixion2154205trans__fixion_
transformation1963075transformation_
transfusion1454235transfus__ion_
transgressions15102295transgressions
transistors1155745trans_is_t_ors
transiting11410775tran___siti_ng
transitional1256225tran___sitional
translation1149485trans__lation_
translocating1654285translocati_ng
transmigrations18132965transmigrations
transmission1454595transmis_sion_
transmutation1554405transmutation_
transpicuous1662195transp__icuous
transpirational1773105transpirational
transpiring1446875transp__iri_ng
transplanting1663965transplanti_ng
transporters1454815transpo_rt_ers
transports1247575transpo_rt___s
transposes1247445transpos____es
transudation1355325trans_udation_
transvaluations1863025transvaluations
transvestisms1871865transves_tisms
transvestites1663085transves_tites

Search took 7 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.343520965.0
2DLD Change Limit95024986.39014870.7
3Display Results98980.0801225.0
 (SQL Overall)178691986.81326227.9
 
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.