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

66 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
mirthless144335(None) 
mirthlessly1951992mirthlessly
mouthless1444712mouthless
pithless13117022pi_thless
worthless1544922worthless
airless73712043air__less
artless73712513_art_less
bathless13127383_bathless
deathless1335223deathless
depthless1542753depthless
dirtiness1039473dirtiness
faithless1543903faithless
fireless112810593fir_eless
fishless1436413fi_shless
giftless1245173gift_less
heathless1535593heathless
hiltless11297123hilt_less
hitless103211193hi_t_less
hurtless11307783hurt_less
ireless72312243_ir_eless
kirtles11309663kirt_le_s
lightless1386073lightless
lintless82710013lint_less
listless8269263list_less
martlets103310483mart_lets
mastless102610023mast_less
matchless1644683matchless
mateless102711293m_ateless
matless93014043m_at_less
meatless103410863meat_less
merciless1344473merciless
meritless1144593meritless
milkless1434773mi_lkless
mindless11319443mi_ndless
miracles1238333miracle_s
miriness10310463mir_iness
mirthfulness2053743mirthfulness
mirths114912993mirth___s
mistiness111911633mistiness
mistress10310703mist_ress
mithers123516733mi_th_ers
mortarless1243103mortarless
murthers1336543murth_ers
myrtles1235733myrt_le_s
nathless11127023_nathless
nightless1386073nightless
pathless13138043_pathless
pitiless10127333pi_tiless
portless10310643port_less
riftless1136943rift_less
ruthless1135413_ruthless
shirtless12266413shirt_less
sighless1276553si_ghless
sightless1385923sightless
skirtless13254423skirt_less
teethless1243703teethless
tintless8239863tint_less
tireless82510263tir_eless
toothless1244683toothless
truthless1244033truthless
virtueless1341933virtueless
vistaless1254573vistaless
wartless11279923wart_less
wireless11249633wir_eless
wishless1435993wi_shless
witless103310983wi_t_less

Search took 8 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.486367677.0
2DLD Change Limit148641666.87321626.8
3Display Results66660.0332000.0
 (SQL Overall)178691667.39224173.6
 
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.