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

119 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
stupefactions205149(None) 
stupefaction1951611stupefaction_
tumefactions1951622_tumefactions
putrefactions2052273putrefactions
tumefaction1851783_tumefaction_
benefactions1952694_benefactions
liquefactions276854liquefactions
malefactions1953144_malefactions
putrefaction1952464putrefaction_
rarefactions1752414_rarefactions
satisfactions18141914satisfactions
stipulations1455444stipula_tions
subtractions1645374s_ubtractions
sulfations13107814s_u_lfa_tions
supernations14410874s_upernations
supinations1348834s_upina_tions
vituperations1852314vitupera_tions
abreactions1544195_abre_actions
attractions1376405at__tractions
benefaction1852825_benefaction_
compactions1946545comp__actions
cooperations1659195coopera_tions
counteractions1855025counteractions
cupellations1643805_cupellations
defections161510205___defections
desperations1559525despera_tions
deuterations1348085deutera_tions
duplications1746285_duplications
enumerations14135515enumera_tions
exactions1838925____exactions
factions133013065_____factions
impactions1645415_imp__actions
imperfections2254005_imperfections
inspections1546435inspe__ctions
interactions14410465_interactions
iterations10413825it__era_tions
itinerations1245685itinera_tions
laureations1145575laure_a_tions
liquefaction265995liquefaction_
malefaction1853405_malefaction_
numerations13127295_numera_tions
olfactions1563875___olfactions
operations12312955__opera_tions
overactions1648215__overactions
pactions122613505___p__actions
perfections1848145___perfections
petrifactions2083565petrifactions
proactions1449345___proactions
pupations1338125_pup__a_tions
rarefaction1652655_rarefaction_
reactions11711715___re_actions
recuperations1746085recupera_tions
redactions1359135___redactions
refections151811645___refections
refractions16127725___refractions
reoperations14410065reopera_tions
satisfaction17142115satisfaction_
saturations1148575satu__ra_tions
sections102714705s___e__ctions
sedations10311255s___eda_tions
seductions1366875s___eductions
segregations1445805segrega_tions
selections12310875s___elections
separations1369275s_epara_tions
situations1038435situ___a_tions
slumpflations2091215slumpflations
speciations1548485s__peciations
squamations2272745squ_ama_tions
stagflations1652865st_agflations
stagnations1244905st_agna_tions
starvations1445055st_arva_tions
stations82415225st____a_tions
stictions1148355st____ictions
stimulations1456205stimula_tions
stipulation1356335stipula_tion_
striations10312795st__ria_tions
strictions1249145st___rictions
stultifications2083535stultifications
stupefiers1552005stupef___iers
stupefies1443835stupef___i_es
stupefying1942015stupef__yi_ng
stylizations2445935styliza_tions
subductions1644505s_u_bductions
subjections2296355s_u_bjections
subjunctions2353465s_ubjunctions
sublations12410115s_u_bla_tions
subsections1597105s_u_bsections
substations1348245s_ubsta_tions
subtraction1545625s_ubtraction_
suctions103012905s_u____ctions
sudations1039905s_u__da_tions
suffocations2053095s_u_ffocations
sulcations1289585s_u_lca_tions
sulfation1288785s_u_lfa_tion_
summations1456785s_u_mma_tions
superadditions1863405s_uperadditions
superalterns1453885s_uperalterns
superatoms1448395s_upera_t_oms
supercautious1753925s_upercautious
superfetations1975065s_uperfetations
superinfections2263415s_uperinfections
supernation13411665s_upernation_
superstations15208145s_uperstations
superstitions15176785s_uperstitions
superventions18125785s_uperventions
supervisions1755035s_upervisions
supination1249885s_upina_tion_
suppletions1553575s_up_pletions
supplications1954915s_upplications
suppositions1654895s_uppositions
suppurations1645205s_uppurations
surjections2075285s_u_rjections
suspirations1445855suspira_tions
tactions102912425_t____actions
tolerations1158135_tolera_tions
tractions11511625_t___ractions
transactions1445885_transactions
typifications2344635_typifications
vituperation1752475vitupera_tion_

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.406440125.6
2DLD Change Limit1247901199.34313356.5
3Display Results1191190.0631888.9
 (SQL Overall)1786911199.81218211.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.