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

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

110 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
expertnesses214484(None) 
expertness1944822expertne_s_s
inexpertnesses2362412inexpertnesses
pertnesses12310312__pertnesses
alertnesses1147233_alertnesses
apartnesses1346823_apartnesses
covertnesses1746333covertnesses
eagernesses1246983eager_nesses
eerinesses10612603e__erinesses
erectnesses1347473e_rectnesses
exactnesses2044343ex_actnesses
expectednesses2662953expectednesses
expertises1947103expert__ises
expresses1837863exp_r__esses
inertnesses1198723_inertnesses
overtnesses1448713_overtnesses
paperinesses1646053paperinesses
peartnesses1338743__peartnesses
pepperinesses1653273pepperinesses
superbnesses1695563superbnesses
abjectnesses2352564abjectnesses
adeptnesses1444834_adeptnesses
aptnesses11168994_ap__tnesses
beerinesses1398924_beerinesses
cheerinesses1765824cheerinesses
curtnesses1238374__curtnesses
dappernesses1743244dapper_nesses
deftnesses1436814__deftnesses
desperatenesses1863744desperatenesses
directnesses1595284directnesses
dopeynesses1744024dope_ynesses
earnestnesses1353664earnestnesses
earwitnesses1543784earwitnesses
effetenesses1854524effetenesses
elderlinesses1453264elderlinesses
electresses1345964e_lectresses
empresses1348164emp_r__esses
emptinesses1545994emp_tinesses
entirenesses1249664entirenesses
epentheses1563804e_penthe_ses
evennesses1345944e_ve_nnesses
exoticnesses2142684exoticnesses
expenses17138374expe__n__ses
experiences22106054exper_iences
expertise1847934expert__ise_
expertisms21114494expert__isms
expertizes28106014expert__izes
explicitnesses2561314explicitnesses
expressed1946214exp_r__essed
expresser1845734exp_r__esser
expressers1944434exp_r__essers
expressos1844554exp_r__essos
extremenesses2252884extremenesses
eyednesses1445814e_ye_dnesses
eyewitnesses1852114eyewitnesses
fierinesses1439234_fierinesses
fleetnesses1445484_fleetnesses
governesses1546724gover_nesses
greatnesses1247794_greatnesses
impurenesses16164434impurenesses
ineptnesses1396384_ineptnesses
inexpertness2152684inexpertne_s_s
innernesses1146734inner_nesses
intentnesses1277124intentnesses
invernesses1447034inver_nesses
leerinesses11119484_leerinesses
malapertnesses1881384malapertnesses
meagernesses1544444meager_nesses
meetnesses1237454__meetnesses
modernnesses1543864modernnesses
neatnesses10310014__neatnesses
opennesses1246314_ope_nnesses
ornerinesses1246574ornerinesses
othernesses1475424other_nesses
pastnesses12910514__pastnesses
patnesses111611794__p_atnesses
perfectnesses2053354perfectnesses
perkinesses1748924__perkinesses
pertness10310094__pertne_s_s
pertusses1145384__pert_usses
pettinesses1338634__pettinesses
portresses1247314__portresses
propernesses1645014proper_nesses
purenesses12810744__purenesses
queernesses2044574queer_nesses
quietnesses2045604quie_tnesses
raptnesses1248524rap__tnesses
recentnesses1465374recentnesses
ripenesses12310374ripe__nesses
selectnesses1446114selectnesses
severenesses1545614severenesses
sexlessnesses1846744sexlessnesses
sheernesses1445844sheer_nesses
shortnesses1446794_shortnesses
silentnesses1275444silentnesses
smartnesses1337144_smartnesses
sobernesses1346594sober_nesses
sparenesses1339174_sparenesses
sportinesses1447874_sportinesses
sprynesses1544974_sp_rynesses
sternnesses1146634_sternnesses
swartnesses1436714_swartnesses
sweetnesses1445724_sweetnesses
tartnesses101110714__tartnesses
temperatenesses19113154temperatenesses
tendernesses1345074tender_nesses
utternesses1145874utter_nesses
vexednesses2244604vex_e_dnesses
waterinesses1567194waterinesses
wetnesses12208214__we_tnesses

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901107.25017212.4
3Display Results1101100.0631746.0
 (SQL Overall)1786911107.70323197.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.