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

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

110 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
transections144676(None) 
transactions1445881transactions
transection1357371transection_
transfections1854851transfections
trajections2044502tra_jections
transaction1346302transaction_
transductions1664292transductions
transecting1447372transecti_ng
transfection1765392transfection_
transitions1148922trans_itions
translations1258362translations
trisections1345632tr_isections
resections121513023_r_esections
trabeations1345343tra_beations
tractions11511613tra___ctions
trajection1944693tra_jection_
transacting1446523transacti_ng
transactional1553423transactional
transactors1364703transact_ors
transduction1584453transduction_
transects1157823transect___s
transfecting1855163transfecti_ng
transfixions2253933transfixions
transfusions1553933transfusions
transition1049703trans_ition_
translation1149483translation_
translocations1664233translocations
transudations1454833transudations
trisection1245983tr_isection_
abjections2145664__abjections
advections1645554__advections
affections1845894__affections
assertions1046584__assertions
bisections14136734__bisections
caseations1258304_ca_seations
confections18411374_confections
connections15410694_connections
consecutions1647034_consecutions
convections18411484_convections
cotransductions2061994cotransductions
dissections14198264_dissections
erections112515194er___ections
exsections1947634__exsections
fractions1449104fra___ctions
granulations1345784granulations
infections15510234__infections
injections1948664__injections
insertions10410344__insertions
inspections1546424__inspections
midsections1644384_midsections
prelections151210454pr_elections
projections2258464pr_ojections
prosecutions1645604pr_osecutions
protections15510694pr_otections
reassertions1253644reassertions
reelections13167944_reelections
refections151811634_r_efections
reflections16178554_reflections
reinfections1745324reinfections
reinjections2144404reinjections
reinsertions1245274reinsertions
reinspections1753094reinspections
rejections191510094_r_ejections
resection111613274_r_esection_
retranslations1454214retranslations
sanctions1138874_san__ctions
sections102714704____sections
subsections1597104_subsections
tactions102912424t_a___ctions
tarnations1038904tarn__ations
trabeation1245884tra_beation_
traction10412684tra___ction_
traditions1147174tra__ditions
trajecting2044294tra_jecti_ng
transactor1265174transact_o_r
transacts1157364transact___s
transcribes1556164trans_cribes
transcriptions1863634transcriptions
transcripts1554434trans_cripts
transductional1782504transductional
transect10410054transect____
transected1347314transect__ed
transepts1146384transept___s
transfects1545724transfect___s
transferrins1554584transferri_ns
transfixion2154204transfixion_
transfusion1454234transfusion_
transgressions15102294transgressions
transistors1155744transist_ors
transiting11410774trans_iti_ng
transitional1256214trans_itional
translating1249434translati_ng
translational1354744translational
translators1156444translat_ors
translocation1554684translocation_
transmissions1554124transmissions
transmutations1653804transmutations
transmuting1456224transmuti_ng
transnational1353914transnational
transpirations1654724transpirations
transpositions1663674transpositions
transposons1354574trans_posons
transudation1355324transudation_
transvestisms1871864transvestisms
transvestites1663084transvestites
trisecting1345504tr_isecti_ng
trisectors1244464tr_isect_ors
truncations1344764trun_cations
venesections1752934venesections
vivisections2052704vivisections

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901108.29615042.2
3Display Results1101100.0631746.0
 (SQL Overall)1786911108.49921024.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.