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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
sanctioning145399(None) 
auctioning1344892_auctioning
functioning1753242functioning
sanctifying2043282sanctifying
sectioning1346292s_ectioning
stanchioning1852142stanchioning
suctioning1345342s_uctioning
cantoning12310883can_t_oning
captioning1545703ca_ptioning
cautioning1345723ca_utioning
fractioning1744333fractioning
mentioning1345793men_tioning
munitioning1453033munitioning
rationing1039783ra__tioning
sanctimonies1652203sanctimonies
sanction1049533sanctio__n_
sanctioned1343903sanction_ed
sanctions1138873sanctio__ns
sanitising11116573saniti_sing
sanitizing20107953saniti_zing
santonin849703san_t_onin_
santonins948453san_t_onins
stationing1145283s_tationing
vacationing1753043vacationing
wantoning1337083wan_t_oning
ambitioning1652784ambitioning
anchoring1548324_anc_horing
antiaging1149674_an_tiaging
anticking1649244_an_ticking
anticling12310694_an_ticling
antidoting1247164_an_tidoting
antiking13412074_an_ti_king
antiquing1947304_an_tiquing
atoning83514874_a__t_oning
auditioning1352704auditioning
calcining1447814calc_i_ning
calcitonin1453924calcitonin_
calcitonins1563434calcitonins
cannoning1237324can__noning
canyoning1536874can__yoning
cartoning12311114ca_rt_oning
cartooning1345884ca_rtooning
conditioning1653684conditioning
factoring1537524fa_ct_oring
fancifying2243884fanc_ifying
fashioning1744394fa_shioning
inclining1248404_incli_ning
intoning9311124_in_t_oning
machining1746934ma_chi_ning
malfunctioning227854malfunctioning
marathoning1752824marathoning
misfunctioning2261234misfunctioning
motioning1247544__motioning
optioning1246554__optioning
partitioning1552974partitioning
patining11312304pa__ti_ning
pavilioning1752374pavilioning
pensioning1345914pen_sioning
petitioning1454044petitioning
pinioning1246864pin__ioning
portioning1347194_portioning
positioning1454554positioning
questioning2153244questioning
ratooning1037174ra__tooning
rattooning1143954ra_ttooning
saining83621394sa___i_ning
sanctified1644294sancti_fied
sanctifier1553494sancti_fier
sanctifies1554984sancti_fies
sanctimonious1771104sanctimonious
sanctimony1751644sancti_mony
sanctionable1652564sanctionable
sanctities1247554sancti_ties
sandwiching2151794sandwiching
sanitating1149644sanit_ating
santolina946264san_t_olina
santonica1145374san_t_onica
sardining1137574sa_rdi_ning
satiating10311804sa__tiating
sectoring1239584s_ect_oring
stoning83717444s___t_oning
suntanning1143984sun_tanning
tensioning1144984ten_sioning

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 Filter1786911488190.453394461.4
2DLD Change Limit148819838.95316622.2
3Display Results83830.0461804.3
 (SQL Overall)178691839.45218905.1
 
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.