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

83 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
meritless114459(None) 
exitless1534882_exitless
meatless103410862me_atless
merciless1344472merciless
artless73712513_ar_tless
beatless103311593be_atless
beltless10297713be_ltless
berryless1442293berryless
brimless1235273_brimless
cerites94823433cerit_e_s
crestless1146783crestless
debtless1135653de_btless
dripless1135243_dripless
editress944933_editress
eeriness8311873eeri_ness
feastless1235043feastless
feetless1137383fe_etless
ferities111416723feritie_s
fernless1136063fer_nless
fretless1138063_fretless
fruitless1244163fruitless
heartless1236393heartless
heatless113011463he_atless
heirless1146053he_irless
herbless1336663her_bless
hitless103211193__hitless
hurtless11307783hur_tless
limitless1142943limitless
mailless10248583m_ailless
martlets103310483mar_tlets
mastless102610023m_astless
matless93014043m__atless
mealless10288363me_alless
meatiness11311183meatiness
meetness1036653me_etness
menseless1145203menseless
merises93421423meri_se_s
meristems1343553meristems
merited10313853merit_e_d
merits8320873merit___s
merles85322763mer__le_s
merriness1138293merriness
metritises1247283metritises
mettles94115023me_ttle_s
miriness10310463miri_ness
mirthless1443353mirthless
musicless1343603musicless
myrtles1235733myr_tle_s
nerveless1243933nerveless
netless739863ne__tless
peltless10267373pe_ltless
periblems1543493periblems
pertness10310093per_tness
portless10310643por_tless
printless1137523_printless
reinless8139443re_inless
resistless1043173resistless
restless82713163re_stless
retitles83612593retitle_s
ribless93410343__ribless
riftless1136943__riftless
rimless9369363__rimless
seatless83213003se_atless
shirtless12266413shirtless
shitless11249243_shitless
skirtless13254423skirtless
slitless8268143_slitless
spiritless1243743spiritless
tentless8229843te_ntless
termless1036233ter_mless
textless15245793te_xtless
thriftless1642213thriftless
veinless11136263ve_inless
ventless11249053ve_ntless
verbless1336033ver_bless
verites103822263verit_e_s
verities111418043veritie_s
vestless11258843ve_stless
wartless11279923war_tless
weariless1234763weari_less
witless103310983__witless
yeastless1234053yeastless
zestless17247433ze_stless

Search took 9 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.423422437.4
2DLD Change Limit148641838.09318366.6
3Display Results83830.0302766.7
 (SQL Overall)178691838.54620909.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.