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

96 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
loneliest94944(None) 
loveliest1246971loveliest
comeliest13410032comeliest
homeliest1448552homeliest
likeliest1346122likeliest
liveliest1247092liveliest
lonelier838002lonelie_r
loneliness1046082loneliness
lordliest1036102lordliest
loudliest1035772loudliest
lovelies1139892lovelies_
lowliest11229472lo_wliest
oneriest8313442_oneriest
auntliest936323auntliest
boneless10310213bonel_ess
boneyest1347843bone_yest
boniest93318993bon__iest
bonniest10310773bon_niest
coaliest10316223co_aliest
costliest1138563costliest
dangliest1137173dangliest
eeliest73516473__eeliest
floweriest1644533floweriest
gangliest1137673gangliest
godliest1039453go_dliest
goggliest1234063goggliest
goodliest1146393goodliest
holiest104319623ho__liest
honestest1247303honestest
jangliest1746383jangliest
jingliest1735973jingliest
jolliest152910363jo_lliest
jowliest18247623jo_wliest
jungliest1744923jungliest
kindliest1436113kindliest
kingliest1436523kingliest
lankiest122912503lan_kiest
leeriest83112883l_eeriest
libelist10310823libeli_st
lineless82711943linel_ess
lingiest93715263lin_giest
liniest73321153lin__iest
lintiest82715913lin_tiest
loamiest102310213lo_amiest
lobelias1047203lobelias_
lobelines1138563lobelines_
localist101613963locali_st
loftiest1139083lo_ftiest
loggiest103011013lo_ggiest
logiest82515543lo__giest
lollies73116923lo_llies_
lonelily1144973loneli_ly
loneness8512093lone_ness
longest84114953lon__gest
longies82916553lon_gies_
longlines1047983longlines_
looniest83313253lo_oniest
loopiest103011323lo_opiest
loppiest122410113lo_ppiest
lousiest82311613lo_usiest
lovefest1444893love_fest
loveless1168573lovel_ess
lovelier1136433lovelie_r
loveliness1345303loveliness
loyalest11146723loyal_est
loyalist111511133loyali_st
luniest73516993lun__iest
manliest102314943man_liest
modelist11310503modeli_st
motliest10310773mo_tliest
nonelect10410283nonel_ect
novelist1149453noveli_st
oiliest72817683_o_iliest
orneriest947403orneriest
panelist10414503paneli_st
portliest11310183portliest
roiliest8312283ro_iliest
slovenliest1452003slovenliest
snellest839493_snellest
sonsiest8313033son_siest
steeliest939643steeliest
tangliest1068423tangliest
timeliest1147233timeliest
tingliest1047683tingliest
tinkliest1336133tinkliest
toneless8610393tonel_ess
toniest73218903ton__iest
toweriest1246533toweriest
unloveliest1452843unloveliest
wifeliest1545883wifeliest
wiseliest1237723wiseliest
wobbliest16275333wobbliest
wonkiest1538943won_kiest
wooliest113011643wo_oliest
woolliest1235853woolliest
zoneless1737823zonel_ess

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.420425454.8
2DLD Change Limit148641966.51622811.7
3Display Results96960.0462087.0
 (SQL Overall)178691966.98225593.1
 
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.