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

42 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
fenthions154423(None) 
fenthion1444611fenthion_
benthons1337972benth_ons
ethions1038482_e_thions
mentions10312892ment_ions
antlions839193_antlions
benthon1237693benth_on_
benthos1238373benth_o_s
centurions1255513centurions
dentations11413633dentations
dentins83419223dent_i_ns
dentitions1148853dentitions
enations83316903_enations
enterons8314153_enterons
enthrone111110113_enthrone
enthrones12910073_enthrones
ethion938813_e_thion_
factions133013063fact_ions
falchions1743913falchions
fanions103713073fan__ions
fashions1437243f_ashions
fenurons1174963fen_urons
fermions1336203fe_rmions
festoons1136443fest_oons
fetations12511383fetations
fictions132410743fict_ions
flections14239213flect_ions
functions1437743functions
gentians937563gent_ians
gnathions1343303gnathions
lections102413843lect_ions
lenitions939473lenitions
mentations12312583mentations
menthols1347043menth_ols
mention9314373ment_ion_
pantheons1446513pantheons
pensions10311693pen_sions
pentagons1246153pentagons
sections102714703sect_ions
tensions8310223ten_sions
venations12311723venations
xanthins1846943xanthi_ns

Search took 8 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.516346300.4
2DLD Change Limit148641427.36020195.8
3Display Results42420.0162625.0
 (SQL Overall)178691427.89222642.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.