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

64 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
tenpence124640(None) 
tendence1148521tendence
tenpences1346541tenpences
lenience1048342lenience
sentence1099862sentence
tangence1146702tangence
tendance1147522tendance
tendences1248082tendences
tendency1445492tendency
tenpenny1342342tenpenny
terpene92310862terpen_e
tuppence1444412tuppence
twopence1542952twopence
benzene1836343benzen_e
defence1339893de_fence
denounce1145103denounce
enhance1239693_enhance
enounce937573_enounce
entente7412953_entente
essence947673_essence
expense16127873_expense
henpeck1843083henpe_ck
leniences1148153leniences
leniency1345313leniency
mergence13137943mergence
penance11313443pen_ance
pence94924453___pence
pendency1646073pendency
penitence1348093penitence
pentene9313793penten_e
refence12312243re_fence
renitence1149063renitence
renounce1047403renounce
sentenced1256683sentenced
sentencer1156383sentencer
sentences11610303sentences
sentience1147663sentience
sequence1946903sequence
sixpence1943543sixpence
spence103813793__spence
tangences1246443tangences
tangency1444563tangency
teepee8314363teepe__e
temperance1644813temperance
tenace82715693ten__ace
tenancy1237503ten_ancy
tendances1247573tendances
tendencies1346343tendencies
tenpin8310583tenpin__
tenpins9410073tenpin_s
tenrec837513tenre_c_
tenrecs936033tenre_cs
tepee74724213te_pe__e
terpenes102111573terpenes
terpenic1247213terpenic
terrene72411033terren_e
thence112010853t__hence
threepence1752033threepence
tuppences1543963tuppences
twopences1642833twopences
unfence1239193_unfence
venene92912523ven_en_e
vengeance1543853vengeance
vergence14128273vergence

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 Filter1786911461620.436409841.7
2DLD Change Limit146162647.26620115.9
3Display Results64640.0134923.1
 (SQL Overall)178691647.71523161.5
 
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.