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

82 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
rarefactional1810176(None) 
rarefaction1652652rarefaction__
rarefactions1752412rarefaction_s
redactional1454353__redactional
affectional1953894_a_ffectional
directional1445444dire__ctional
factional1478764____factional
fractional1547134_fr__actional
interactional1557004interactional
malefaction1853404malefaction__
malefactions1953144malefaction_s
narrational1145444nar_ra_tional
radiational1245954ra_dia_tional
recreational1455174recre_a_tional
reductional1454594__reductional
reflectional1753994__reflectional
relational1047714__rela_tional
tractional1248054_tr__actional
transactional1553424tra_nsactional
variational1444774var_ia_tional
aberrational1453485_aberrational
abreaction1444655abre_action__
abreactions1544195abre_action_s
abstractional1753265abstractional
aggregational1662225aggrega_tional
agitational1244845_agita_tional
annexational1953265annexa_tional
avocational1645185_avoca_tional
benefaction1852825benefaction__
benefactions1952695benefaction_s
bisectional1554645bise__ctional
contractional1756065contractional
correctional1675325cor_rectional
correlational15113675correla_tional
derivational1654265deriva_tional
fictional1477805____fictional
frictional1546255_fr__ictional
generational1354825genera_tional
gradational1354475_grada_tional
gravitational1762555gravita_tional
gyrational1444745gyr__a_tional
ideational1146505_ide_a_tional
irrational1047215_ir_ra_tional
irrotational1254025irrota_tional
lactational1344655la_cta_tional
maturational1454185matura_tional
metafictional2071265metafictional
navigational1653295naviga_tional
negational1147155__nega_tional
nonfictional1754855_nonfictional
operational1347525_opera_tional
paratactical1852925paratacti_cal
perorational1446395perora_tional
prevocational2054015_prevocational
probational1547085_proba_tional
productional1794715_productional
projectional2355425_projectional
putrefaction1952465putrefaction__
putrefactions2052275putrefaction_s
rational8412545__r__a_tional
reaction10612605__re_action__
reactionary1653695__re_actionary
reactions11711715__re_action_s
redaction1259665__redaction__
redactions1359135__redaction_s
refection141512285__refection__
refections151811645__refection_s
refraction15137905__refraction__
refractions16127725__refraction_s
repetitional1453725repe_titional
reputational1474585reputa_tional
rotational1048095__rota_tional
salutational1253325saluta_tional
salvational1443715sa_lva_tional
sectional1149425__se__ctional
transductional1782515transductional
translational1354745transla_tional
transnational1353915transna_tional
tumefaction1851785tumefaction__
tumefactions1951625tumefaction_s
valuational1444045va_lua_tional
vegetational1653375vegeta_tional

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.393454684.5
2DLD Change Limit124790829.31313399.5
3Display Results82820.0461782.6
 (SQL Overall)178691829.75218323.5
 
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.