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

122 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
functions143774(None) 
function1337841function_
junctions1835941junctions
unctions1039731_unctions
auctions104012142au_ctions
cofunctions1845012cofunctions
factions133013062f_actions
fictions132410742f_ictions
flections14239212flections
fractions1449102fractions
frictions1448032frictions
functional15116672functional
functioned1643992functioned
functors1335742funct_ors
furcations1547532furcations
inunctions1246752inunctions
junction1736202junction_
lunations9310722lunations
munitions1138172munitions
punitions1137922punitions
ructions102811682ru_ctions
sanctions1138872sanctions
suctions103012902su_ctions
unction9310662_unction_
actions94218513__actions
adjunctions2143143adjunctions
adnations1039753adnations
affections1845893affections
agnations10310033agnations
auction93412933au_ction_
auditions1078753auditions
bunions92210473bun__ions
coactions1349743coactions
cofunction1745253cofunction_
conations111318903conations
cunctations1576153cunctations
dictions111812673_dictions
disfunctions1854523disfunctions
donations101112353donations
durations10311463durations
dysfunctions2152133dysfunctions
eductions1268773eductions
ejections18249963ejections
elections112414973elections
enations83316903_enations
erections112515213erections
evections142510693evections
evictions14228623evictions
exactions1838923exactions
expunctions2243633expunctions
faction122613333f_action_
factious13239243f_actious
falchions1743913falchions
fanions103713073fan__ions
fenthions1544233fenthions
fetations12511383fetations
fiction122010733f_iction_
fixations1936353fixations
flection13239563flection_
foundations1543433foundations
fraction1359483fraction_
fractious1456143fractious
friction1347913friction_
fruitions12106113fruitions
functionary1953753functionary
functioning1753243functioning
functionless1752413functionless
functor1235203funct_o_r
furcation1448353furcation_
fusions1039153fu__sions
fustians1146403fu_stians
futons93911513fu__t_ons
gumptions1443773gumptions
guncottons1351463guncottons
ignitions1045803ignitions
inactions1139323inactions
injunctions2044883injunctions
inunction1146893inunction_
junctional19105363junctional
lections102413843_lections
lenitions939473lenitions
lunation8311923lunation_
luncheons1443603luncheons
luxations1637273luxations
malfunctions1952663malfunctions
mentions10312893men_tions
misfunctions1953713misfunctions
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
suction93713043su_ction_
sudations1039903sudations
sulcations1289583sulcations
tactions102912423_tactions
tractions11511623tractions
truncations1344763truncations
tuitions838283tu_itions
unctuous1044853_unctuous
unions64216753_un__ions
venations12311723venations
zonations18139313zonations

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411227.84318952.1
3Display Results1221220.0462652.2
 (SQL Overall)1786911228.06222164.6
 
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.