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

86 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
franchising205384(None) 
enfranchising2261502enfranchising
francizing2545372franc_izing
branching17289263branch__ing
cranching17278733cranch__ing
disfranchising2461383disfranchising
franchise1746003franchis__e
franchised1943963franchis_ed
franchisee1854453franchis_ee
franchisees1953073franchisees
franchiser1843623franchis_er
franchisers1952813franchisers
franchises1855633franchis_es
franchisor1852613franchis_or
franchisors1952373franchisors
frenchifying2751733frenchifying
frenching18267753french__ing
practising1586363pra_ctising
ranching141712043_ranch__ing
anchoring1548324__anchoring
anchusin1344774__anchusin_
anchusins1444544__anchusins
archaising1645104__archaising
archiving1844764__archiving
blanching17297094blanch__ing
brachiating1944434bra_chiating
braising113014564bra___ising
branchline1744124branch_line
brandishing1853364bran_dishing
brunching17316484brunch__ing
canalising1349364_canalising
canonising1346584_canonising
catechising1953544catechising
coanchoring1943244coanchoring
craunching1843314craunch__ing
crunching17297004crunch__ing
dramatising1554394dramatising
drenching16256034drench__ing
enchasing1567734__enchasing
fancifying2243884f_ancifying
fancying1735354f_anc__ying
fantasising1554214f_antasising
faradising1545274f_aradising
finalising1446674f_inalising
flenching18296704flench__ing
flinching18245834flinch__ing
fractioning1744334fra_ctioning
fracturing1643934fra_cturing
francolin1443774franc_olin_
francolins1543874franc_olins
franking164310864fran___king
fraughting1843064fraugh_ting
frenchified2352464frenchified
frenchifies2252864frenchifies
graecizing2343764graec_izing
incising11411094__inc_ising
kyanising1743874kyan__ising
laicising1245624_laic_ising
machining1746934_ma_chining
organising1245584organ__ising
practicing1775584pra_cticing
praising113214564pra___ising
prancing132612164pranc___ing
precising14413274pr_ec_ising
racheting1537794_ra_cheting
raising83220534_ra___ising
ratcheting1643784_ratcheting
rawhiding1743114_ra_whiding
sanitising11116574_sanitising
stanching1538084stanch__ing
stanchioning1852144stanchioning
trachling1537824tra_ch_ling
trancing112812024tranc___ing
transcribing1754244transcribing
transfixing2254804transfixing
transfusing1554674transfusing
transhipping2073224transhipping
transiting11410774tran_siting
transpiring1446874transpiring
transposing1455454transposing
trauchling1643474trauch_ling
trenching15227654trench__ing
tyrannising1552774tyran_nising
unanchoring1752184unanchoring
urbanising1344654urban__ising
wrenching18276274wrench__ing

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.423422437.4
2DLD Change Limit148819868.64017224.4
3Display Results86860.0461869.6
 (SQL Overall)178691869.10919617.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.