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

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

65 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
mentioned124683(None) 
mentioner1146691mentioner
mention9314372mention__
mentioners1245342mentioners
mentions10312892mention_s
mentored1138002ment_ored
motioned1137452m_otioned
munitioned1353942munitioned
pensioned1246652pensioned
sectioned1246522sectioned
tensioned1045612tensioned
ambitioned1552973ambitioned
auctioned1244953auctioned
bastioned1246863bastioned
cantoned111411523cant_oned
captioned1445763captioned
cautioned1245363cautioned
centones10313663cent_ones
dentiled1039743denti_led
dentine83320243denti_ne_
dentines93418403denti_nes
destined103312453desti_ned
dimensioned1552463dimensioned
engined9119893_engi_ned
enjoined16215723_enjoined
enthroned1396883_enthroned
enticed101411193_enti_ced
entitled967503_entitled
entoiled968283_entoiled
entwined1235843_entwined
environed1342843_environed
festooned1344303festooned
functioned1643993functioned
intoned8811993_int_oned
jettisoned1851593jettisoned
lesioned936903le_sioned
menadione1243783menadione_
menadiones1343783menadiones
menthene1347033menthene_
menthenes1447703menthenes
mentioning1345793mentioning
mestinoes1157313mestinoes
missioned1248603missioned
monitored1245583monitored
motioner1037593m_otioner
mullioned1245733mullioned
mutined103311353m_uti_ned
optioned1146383_optioned
pennoned1136313pen_noned
pensione1039773pensione_
pensioner1146663pensioner
pensiones11410003pensiones
petioled1137993pe_tioled
petitioned1344173petitioned
pinioned1137513pin_ioned
portioned1248333portioned
questioned2043183questioned
rationed9410093_rationed
sanctioned1343903sanctioned
sentinel838703senti_nel
stationed1046143stationed
suctioned1245283suctioned
tenoned839363ten__oned
tensioner945913tensioner
wantoned12117223want_oned

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.436409841.7
2DLD Change Limit148641657.51619776.6
3Display Results65650.0302166.7
 (SQL Overall)178691657.98222386.7
 
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.