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

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

59 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
franchisees195307(None) 
franchisee1854451franchisee_
franchisers1952811franchisers
franchises1855631franchis_es
franchise1746002franchis_e_
franchised1943962franchis_ed
franchiser1843622franchis_er
franchisors1952372franchisors
enfranchises2052273enfranchis_es
franchising2053843franchising
franchisor1852613franchis_or
francizes2346793franc_i_zes
frenchifies2252863frenchifies
rachises131412413_ra_chis_es
brachiates1746354bra_chiates
branches153613804branch___es
branchiae16186314branchi_ae_
branchier1637134branchi__er
branchiest1746714branchi_est
branchless1743304branch_less
branchlets1743804branch_lets
branchlines1843614branchlines
brandishes1645894bran_dishes
bronchioles1852864bronchioles
cranches153114544cranch___es
crunchiness1843284crunchiness
disfranchises2262094disfranchis_es
enfranchise1952264enfranchis_e_
enfranchised2161914enfranchis_ed
fanciers13358084f_anc_i_ers
fancies124018784f_anc_i__es
fancifies1767084f_anc_ifies
fanciless1444604f_anc_iless
fanciness1437674f_anc_iness
fiancees1335104fianc___ees
fracases1336994fra_c_as_es
fraises104215694fra___is_es
framboises1742694frambois_es
franciums1644414franc_i_ums
francize2246854franc_i_ze_
francized2445584franc_i_zed
franknesses1845604franknesses
frenches163311634french___es
frenchified2352464frenchified
fricassees1551794fr_icassees
frisees104411694fr____isees
manchineel1752114_manchineel
manchineels1851254_manchineels
orchises1338774or__chis_es
practises1349624pra_ctis_es
rachides141511224_ra_chi_des
ranchers133311794_ranch__ers
ranches123620114_ranch___es
ranchless1444454_ranch_less
raunchiness1642884_raunchiness
rhachises1763974_rhachis_es
tachismes1684224_ta_chismes
tachistes1466044_ta_chistes
tranches132915514tranch___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 Filter1786911488190.440406115.9
2DLD Change Limit148819598.92016683.7
3Display Results59590.0331787.9
 (SQL Overall)178691599.39319023.8
 
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.