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

95 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
greedless114489(None) 
breadless1235942breadless
deedless10318252_deedless
gradeless11236702gradeless
greediest1147552greediest
greediness1245832greediness
greenlets1044702greenlets
greenness1046792greenness
heedless12278812_heedless
needless9308332_needless
seedless9319512_seedless
treadless1036002treadless
treeless839282tree_less
weedless12287962_weedless
bedless1039703__bedless
beefless1335493_beefless
brandless1236123brandless
breeders11368893breed_ers
breezeless2141693breezeless
briefless1443613briefless
broodless1235033broodless
cheekless1873883cheekless
cheerless1495293cheerless
crestless1146783crestless
crewless1335403cr_ewless
dreamless1243513dreamless
endless839833__endless
feeless103511103_fee_less
feetless1137383_feetless
freeness11710443free_ness
fretless1138063fr_etless
friendless1442543friendless
gateless9279953gate_less
gearless937373g_earless
glandless1134163glandless
glebeless1242953glebeless
godless938403g__odless
graceless12226883graceless
grainless1035883grainless
grandness1138303grandness
grassless1034303grassless
grateless10277573grateless
graveless13226693graveless
greaseless1143483greaseless
greatness1036893greatness
greedier1036083greedie_r
greeds84314283greed___s
greegrees1142853greegrees
greenest9312623gree_nest
greenies9312673greenie_s
greeniest1039033greeniest
greenlet948513greenle_t
greeters92610113gree_ters
greyness1235243gr_eyness
griddles1145753griddle_s
groundless1243473groundless
groveless13235363groveless
gruelers936173grue_lers
gruellers1034183gruellers
guideless1143843guideless
headless12289863_headless
heelless11257653_heelless
ireless72312243ir_e_less
keelless12236193_keelless
leadless9248793_leadless
needlers9287423_needlers
needles83211563_needle_s
orderless1044313orderless
peerless1037513_peerless
prebless1236823pr_ebless
reckless14257973_reckless
reddles93315773_reddle_s
redlegs936823_r_edlegs
redness82012443_r_edness
redress82511873_r_edress
reediest92815423_reediest
reediness10239613_reediness
reelers73520273_ree_lers
reinless8139433_reinless
remediless1342293_remediless
restless82713163_restless
rindless92510193_rindless
roadless937703_roadless
rodless8310073_r_odless
sheetless1235823sheetless
sleepless1144553sleepless
threadless1442473threadless
treadlers1045893treadlers
treadles939703treadle_s
treddles1036263treddle_s
tweedles1234113tweedle_s
weldless12285813_weldless
wheedlers1643193wheedlers
wheedles1534643wheedle_s
wheelless1543763wheelless

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.1701051123.5
2DLD Change Limit148641959.34615904.2
3Display Results95950.0462065.2
 (SQL Overall)178691959.56218687.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.