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

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

35 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
disenfranchises24221781disenfranchises_
disenfranchise23231922disenfranchise__
disenfranchised25251722disenfranchise_d
disfranchises2262093dis__franchises_
disfranchise2162234dis__franchise__
disfranchised2361884dis__franchise_d
enfranchises2052274___enfranchises_
disfranchising2461385dis__franchising
enfranchise1952265___enfranchise__
enfranchised2161915___enfranchise_d
disbranches1953526dis__branch__es_
enfranchising2261506___enfranchising
franchises1855636_____franchises_
degeneracies1653557degenera_c_i_es_
disbranched2052807dis__branch__e_d
disbranching2152487dis__branchi__ng
discographies2284587discogra_phi_es_
discordancies1962617discordanc_i_es_
discrepancies2061777discrepanc_i_es_
disentangles1452697disen_tan__gles_
dispraises1347397dis__pra___ises_
disseverances1962117disseveranc___es_
enfranchisement2581367___enfranchisement
franchise1746007_____franchise__
franchised1943967_____franchise_d
franchisee1854457_____franchise_e
franchisees1953077_____franchisees
franchiser1843627_____franchise_r
franchisers1952817_____franchisers
hierarchies1973527hi_e__rarchi_es_
hierarchizes29152167hi_e__rarchizes_
inerrancies1355047_ine_rranc_i_es_
infancies1446977_i__nf_anc_i_es_
itinerancies1452797_itineranc_i_es_
sennachies1544047__sen_na_chi_es_

Search took 10 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 Filter178691950240.1261418182.5
2DLD Change Limit95024359.6069892.2
3Display Results35350.0162187.5
 (SQL Overall)178691359.74818331.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.