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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 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
wheatless153400(None) 
heatless113011461_heatless
beatless103311592_beatless
hatless103813442_h_atless
headless12289862_headless
heartless1236392_heartless
heathless1535592_heathless
meatless103410862_meatless
pleatless1134612pleatless
seatless83213002_seatless
sheetless1235822sheetless
whatness1435092wh_atness
wheatens1454662wheat_ens
wheelless1543762wheelless
whelpless1742052whelpless
beakless14297383_beakless
beamless12327003_beamless
beltless10297713_beltless
breadless1235943breadless
breathless1543533breathless
chadless1436403ch_adless
chartless1435703chartless
cheapness1643743cheapness
cheaters133613513cheat_ers
checkless2044233checkless
cheekless1873883cheekless
cheerless1495293cheerless
coatless1039693_coatless
crestless1146783crestless
deathless1335223_deathless
debtless1135653_debtless
dreamless1243513dreamless
earless74316073__earless
eventless1244603eventless
fatless103212203__fatless
fearless1137873_fearless
feastless1235043_feastless
feetless1137383_feetless
fretless1138063fre_tless
gearless937373_gearless
greatness1036903greatness
haltless11308443_haltless
hapless123311333_h_apless
healers104319463_hea_lers
heaters104225223_heat_ers
heathens143210153_heathens
heathers143914733_heathers
heedless12278813_heedless
heelless11257653_heelless
heirless1146053_heirless
helmless1334273_helmless
helpless1335063_helpless
herbless1336663_herbless
hiltless11297123_hiltless
hitless103211193_h_itless
hurtless11307783_hurtless
idealess935653idea_less
idealless1042953idealless
leadless9248793_leadless
leafless11246573_leafless
leakless12246983_leakless
matless93014043__matless
mealless10288363_mealless
neatness839153_neatness
netless739863_ne_tless
peakless14236683_peakless
peltless10267373_peltless
poetless1038723poe_tless
restless82713163_restless
scentless1135113scentless
seamless10238723_seamless
shearlegs1342493shearlegs
sheathers1557553sheathers
sheathes14610193sheathe_s
shiftless15265303shiftless
shirtless12266413shirtless
shitless11249243sh_itless
tearless848713_tearless
tentless8229843_tentless
textless15245793_textless
thawless1434083th_awless
theaters114211903theat_ers
theatres11298633theatre_s
thewless1433923the_wless
threadless1442473threadless
treadless1036003treadless
ventless11249053_ventless
vestless11258843_vestless
waistless1235093waistless
warless104015103w__arless
wartless11279923w_artless
wattless11268723w_attless
wayless13308243w__ayless
weakness1535353w_eakness
weariless1234763w_eariless
weathers143412833w_eathers
webless1237003w_e_bless
weedless12287963w_eedless
weldless12285813w_eldless
wetness10277723w_e_tness
whalers13529703wh_a_lers
whales124716943wh_a_le_s
wheals124512523whea_l__s
wheatear1442563wheat_ear
wheatears1542683wheatears
wheaten1336403wheat_e_n
wheatland1641953wheatland
wheatlands1751993wheatlands
wheats125013223wheat___s
wheedlers1643193wheedlers
wheedles1534643wheedle_s
wheelers14287733whe_elers
wheeples1634743wheeple_s
whetters14246653whe_tters
whistlers1595163whistlers
whistles14108213whistle_s
whittlers1594333whittlers
whittles1496673whittle_s
whortles14306743whortle_s
witless103310983w__itless
womanless1443383womanless
wreathers15257493wreathers
wreathes14299893wreathe_s
wrestlers12306103wrestlers
wrestles113310063wrestle_s
yeastless1234053_yeastless
zestless17247433_zestless

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.440406115.9
2DLD Change Limit1486411279.12316293.0
3Display Results1271270.0462760.9
 (SQL Overall)1786911279.60918596.2
 
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.