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

89 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
tendances124757(None) 
tendance1147521tendance_
tendences1248081tendences
attendances1483192attendances
enhances1339292_enhances
intendances1445562intendances
nondances1247802nondances
penances12312442pen_ances
tenaces92814512ten_a_ces
tenancies1149172ten_ancies
tendence1148522tendence_
tendencies1346342tendencies
tenpences1346542tenpences
vendaces1457182venda_ces
abidances1445593abidances
abundances1543313abundances
andantes9310853_andantes
ascendances16123833ascendances
attendance1383363attendance_
bechances1847613bechances
bedunces1345513be_dunces
dances95120653___dances
defiances1557033defiances
denounces1245413denounces
dependances1754853dependances
deviances1566493deviances
endanger1045853_endanger
endangers1144943_endangers
endashes12217453_endashes
endurances1344933_endurances
enfaces122110913_enfa_ces
enhance1239693_enhance_
enhanced1436623_enhanced
enhancer1346683_enhancer
enhancers1445103_enhancers
enlaces92313393_enla_ces
enounces1037603_enounces
entrances11310953_entrances
feasances1445403feasances
finances1338663fin_ances
gendarmes1343923gendarmes
guidances1344773guidances
henbanes1336583henban_es
hindrances1644843hindrances
intendance1345723intendance_
iterances1148913ite_rances
leniences1148153leniences
lindanes939173lindan_es
menaces112715523men_a_ces
nances83618643__n_ances
nondance1148243nondance_
nondancer1245593nondancer
nondancers1344643nondancers
nuances938523__nuances
ordnances1244753ordnances
outdances12198503outdances
penance11313443pen_ance_
penanced1338163pen_anced
pendants1139093pendan_ts
pendencies1547023pendencies
pentanes10316083pentan_es
reliances1139623reliances
renounces1147543renounces
riddances1343893riddances
seances93015343se__ances
sentences11610303sentences
sonances10310263son_ances
tangences1246443tangences
tenace82715693ten_a_ce_
tenancy1237503ten_anc_y
tenanted937043ten_anted
tenants7311013ten_an_ts
tendency1445493tendenc_y
tendinous1044623tendinous
tendons8311473tendon__s
teniases838623tenia_ses
tennies73017973ten__nies
tenpence1246403tenpence_
tentacles1146713tentacles
tentages91011043tenta_ges
terraces102712253terra_ces
terranes82514433terran_es
tetanies8513553te_tanies
trances93919643t__rances
vendables15165153vendables
vendace1357363venda_ce_
vengeances1643643vengeances
verdancies1645233verdancies
voidances1544473voidances

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.440406115.9
2DLD Change Limit148641897.06321045.0
3Display Results89890.0302966.7
 (SQL Overall)178691897.53323721.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.