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

118 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
transactional155342(None) 
transaction1346302transaction__
transactions1445882transaction_s
transductional1782502transductional
transitional1256222trans_itional
translational1354742translational
transnational1353912transnational
tractional1248043tr___actional
transacting1446523transacti_n_g
transection1357373transection__
transections1446763transection_s
transfusional1662413transfusional
fractional1547124fr___actional
gradational1354474gra_da_tional
radiational1245944_radia_tional
rarefactional18101764_rarefactional
redactional1454344_r_edactional
sensational1146384_sensa_tional
traditional1255384tra__ditional
transactinide16132104transactinide
transactor1265174transact_o__r
transactors1364704transact_o_rs
transcriptional1992244transcriptional
transduction1584454transduction__
transductions1664294transduction_s
transecting1447374transecti_n_g
transfection1765394transfection__
transfections1854854transfection_s
transition1049704trans_ition__
transitionally1763124trans_itionally
transitions1148924trans_ition_s
translation1149484translation__
translations1258364translation_s
transpersonal1562534transpersonal
transpirational1773094transpirational
transpositional17112334transpositional
abstractional1753255abstractional
adaptational1572795adapta_tional
affectional1953885__affectional
avocational1645185__avocational
binational1246375_bin_a_tional
bisectional1554635__bisectional
connectional1646715_connectional
contractional1756055contractional
convectional1947035_convectional
factional1478765____factional
foundational1652845founda_tional
frictional1546245fr___ictional
functional15116665_fun__ctional
gravitational1762555gravitational
incantational1553565incanta_tional
insertional1147455__insertional
interactional1556995interactional
irrational1047205ir__ra_tional
irrotational1254025irrota_tional
junctional19105355_jun__ctional
lactational1344655_lacta_tional
narrational1145435_narra_tional
national8311535___n_a_tional
nonfictional1754845_nonfictional
nonnational11107835_nonna_tional
nonrational11109115_nonra_tional
organizational2462085organizational
orientational1353795orienta_tional
prevocational2054015prevocational
probational1547085pr_oba_tional
productional1794705pr_oductional
projectional2355415pr_ojectional
ransacking1744425_ransacki_n_g
rational8412545_r___a_tional
reductional1454585_r_eductional
reflectional1753985_reflectional
relational1047715_r_ela_tional
rotational1048095_r_ota_tional
salvational1443715_salva_tional
sectional1149415____sectional
subnational1354575subn_a_tional
suctional1147685____suctional
supranational1552995supran_a_tional
tarnation9310095tarn_a_tion__
tarnations1038905tarn_a_tion_s
tensional946215t_ens___ional
terminational1553485termina_tional
trabeation1245885trabea_tion__
trabeations1345365trabea_tion_s
traction10412685tr___action__
tractions11511625tr___action_s
trajection1944695tra_jection__
trajections2044515tra_jection_s
transact1049825transact_____
transacted1346635transact___ed
transacts1157365transact____s
transalpine1365035transalpi_n_e
transaminase1453375transa_mi_nase
transeptal1254745transept___al
transfecting1855165transfecti_n_g
transfixion2154205transfixion__
transfixions2253935transfixion_s
transfusion1454235transfusion__
transfusions1553935transfusion_s
transiting11410775trans_iti_n_g
translating1249435translati_n_g
translocation1554685translocation__
translocations1664235translocation_s
transmittal1354005trans__mittal
transmuting1456225transmuti_n_g
transnatural1272295transnat_ural
transudation1355325transudation__
transudations1454835transudation_s
trisection1245985tr_isection__
trisections1345645tr_isection_s
truncation1245455trunca_tion__
truncations1344765trunca_tion_s
ultrarational1363515ultra_ra_tional
unsensational1353665unsensa_tional
valuational1444045_valua_tional
variational1444775_varia_tional
vivisectional2162095vivisectional

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.1401276364.3
2DLD Change Limit1247901188.89014037.1
3Display Results1181180.0961229.2
 (SQL Overall)1786911189.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.