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

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

104 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
junctions183594(None) 
functions1437741functions
junction1736201junction_
unctions1039731_unctions
adjunctions2143142adjunctions
auctions104012142au_ctions
function1337842function_
injunctions2044882injunctions
inunctions1246752inunctions
junctional19105362junctional
lunations9310722lunations
munitions1138172munitions
punitions1137922punitions
ructions102811682ru_ctions
sanctions1138872sanctions
suctions103012902su_ctions
unction9310662_unction_
actions94218513__actions
adjunction2043293adjunction_
adnations1039753adnations
agnations10310033agnations
auction93412933au_ction_
auditions1078753auditions
bunions92210473bun__ions
coactions1349743coactions
cofunctions1845013cofunctions
conations111318903conations
conjunctions2345383conjunctions
cunctations1576153cunctations
dictions111812673_dictions
disjunctions2254073disjunctions
donations101112353donations
durations10311463durations
eductions1268773eductions
ejections18249963ejections
elections112414973elections
enations83316903_enations
erections112515213erections
evections142510693evections
evictions14228623evictions
exactions1838923exactions
expunctions2243633expunctions
factions133013063_factions
fictions132410743_fictions
flections14239213flections
fractions1449103fractions
frictions1448033frictions
functional15116673functional
functioned1643993functioned
functors1335743funct_ors
furcations1547533furcations
gumptions1443773gumptions
guncottons1351463guncottons
ignitions1045803ignitions
inactions1139323inactions
injunction1945093injunction_
inunction1146893inunction_
juncoes16338073junc__oes
juncos15449233junc__o_s
junctures1844033junctures
juniors1475783jun__iors
juntos134110843jun_t_o_s
lections102413843_lections
lenitions939473lenitions
lunation8311923lunation_
luncheons1443603luncheons
luxations1637273luxations
mentions10312893men_tions
monitions11310883monitions
munition1038763munition_
munnions1035273mun_nions
muntins92715133mun_ti_ns
mutations111211453mutations
nations74720563__nations
nonactions1248373nonactions
notions74014483__notions
nuncios937113nunc_io_s
nunnations1095903nunnations
nutations91411763nutations
pactions122613503_pactions
puncheons1643913puncheons
punctations1585353punctations
punition1038373punition_
pupations1338123pupations
questions1845523questions
reactions11711713reactions
ruction93611613ru_ction_
ructious10277083ru_ctious
ruinations1039603ruinations
sanction1049533sanction_
sections102714703_sections
stictions1148353stictions
subjunctions2353463subjunctions
suction93713043su_ction_
sudations1039903sudations
sulcations1289583sulcations
tactions102912423_tactions
tractions11511623tractions
truncations1344763truncations
tuitions838283tu_itions
unctuous1044853_unctuous
unions64216753_un__ions
venations12311723venations
zonations18139313zonations

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411046.36023371.2
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.82626178.0
 
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.