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

47 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
knockless144244(None) 
flockless1843162flockless
frockless1843452frockless
knockers13285732knock_ers
knotless1264572kno_tless
knucklers1483042knucklers
knuckles1384452knuckle_s
neckless14236432_neckless
rockless14297292_rockless
sockless14267792_sockless
backless162910633_backless
checkless2044233checkless
clickless1743983clickless
cockles153414643_cockle_s
cookless14258633_cookless
feckless17225783_feckless
fleckless1842893fleckless
forkless15267433_forkless
hookless151238363_hookless
inkless11348713in__kless
keckles12318763k_eckle_s
knackers13286843knack_ers
knickers13306723knick_ers
knocked13236303knock_e_d
knocker12296393knock_e_r
knockoffs2051003knockoffs
knockouts1441943knockouts
knocks11397443knock___s
knollers12255143kno_llers
knuckle1254233knuckle__
knuckled1463563knuckle_d
knuckler1383623knuckle_r
knuckliest1542553knuckliest
luckless14265893_luckless
nickles133713823_nickle_s
normless10235923_normless
noseless839513_noseless
noteless839403_noteless
nounless837253_nounless
reckless14257973_reckless
snowless1145633sno_wless
stackless1555933stackless
suckless14288823_suckless
tackless14419483_tackless
trackless15246723trackless
wickless1736083_wickless
workless15276803_workless

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641479.05016424.4
3Display Results47470.0133615.4
 (SQL Overall)178691479.21919382.9
 
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.