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

55 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
scrannels114351(None) 
scrannel1044031scrannel_
cannels93413362_c_annels
channels13388492_channels
scanners10379702sc_anners
branners104010923_branners
cancels114113313_c_ancels
cannel84216403_c_annel_
canners93822663_c_anners
chancels15439083_chancels
channel123910483_channel_
charnels13328173_charnels
chunnels13304553_chunnels
cracknels1743433_cracknels
cranes84330753_cra_ne_s
crankles143510153_crankles
crannies10313013_crannies
crannogs1143783_crannogs
crenels93711013_cr_enels
flannels1134843_flannels
grapnels1134393_grapnels
mischannels1852193mischannels
rechannels1543183rechannels
ronnels7318613__ronnels
runnels7329153__runnels
scalpels12345883sc_alpels
scandals1136993sc_andals
scanned104110893sc_anne_d
scanner94411813sc_anne_r
scantness1135733sc_antness
scariness11310183scariness
scrabbles15206283scrabbles
scrambles15146383scrambles
scramjets2052063scramjets
scrapers125510533scra_pers
scrapes116217663scra_pe_s
scrapies124612483scrapie_s
scrappers1545863scrappers
scrapples1534803scrapples
scrawlers1434753scrawlers
scrawls12177283scra__wls
scrawniness1652153scrawniness
screeners1136733screeners
scunners10357303sc_unners
shrapnel1342133shrapnel_
spancels1245273s_pancels
spaniels1045963s_paniels
spanners103710773s_panners
strainers9510383strainers
stranders10389933stranders
strangely1345413strangely
strangers104112163strangers
stranges94516763strange_s
strangles103011553strangles
trunnels844513_trunnels

Search took 7 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.406440125.6
2DLD Change Limit148641556.47022973.9
3Display Results55550.0301833.3
 (SQL Overall)178691556.90625874.7
 
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.