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

77 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
tenaille84681(None) 
tenailles946321tenailles
canaille1048412canaille
taille63116922t__aille
tenable93214492tena_ble
tenail64516112tenai_l_
tenails73713922tenai_ls
tensible1037242tensible
tensile72612732tensi_le
braille939713_braille
canailles1148273canailles
cenacle1139123cena_cle
centile94217183centi_le
chenille1354593chen_ille
deniable11312083deniable
denticle1137773denticle
enable83318483_ena_ble
enisle63412093_en_isle
ensile62616473_ensi_le
entitle7610293_entitle
faille93414743__faille
fenagle11197153fena_gle
fencible1545603fencible
genially12129523genially
gentile83515293genti_le
gerbille1144613gerbille
manille92613273man_ille
menially131111093menially
penalise101013763penalise
penalize19912753penalize
penally121111773pena_lly
pencilled1445643pencilled
penciller1344953penciller
penile82219603pen_i_le
pensile92713543pensi_le
renail65020763renai_l_
renailed92512803renailed
renails74917263renai_ls
rendible11128353rendible
reveille1145333reveille
rocaille1045383rocaille
senile63420213sen_i_le
sensible1037853sensible
sensilla845623sensilla
sensillae944113sensillae
stencilled1342803stencilled
stenciller1252983stenciller
tailles72516473t__ailles
tangible1145603tangible
tealike111111083te_alike
teazle15329553te_a_zle
tenably122210453tena_bly
tenace82715693tena__ce
tenacula1044493tenacula
tendrilled1242963tendrilled
teniae64517353ten_i_ae
tensibly1345143tensibly
tensilely1244123tensilely
tensive10269913tensi_ve
tentacle1037693tentacle
tentie62521183tenti__e
tentlike1236903tentlike
terrible1046643terrible
testicle1037443testicle
textile1437223texti_le
toenail738783toenai_l_
toenailed1043483toenailed
toenails847213toenai_ls
tonally10311373tona_lly
trenail7410813trenai_l_
trenails869843trenai_ls
tuille63012643t__uille
tunable92511313tuna_ble
tunicle9308033tun_icle
venally13119563vena_lly
vendible14156473vendible
venially1499423venially

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.453394461.4
2DLD Change Limit146162777.01620832.7
3Display Results77770.0332333.3
 (SQL Overall)178691777.50223819.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.