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

104 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
overtness123822(None) 
covertness1545501covertness
alertness946052alertness
governess1346172gover_ness
inertness947972inertness
overdress1346592overdress
overstress1345762overstress
overtnesses1448712overtnesses
overtones121011852overtone_s
pertness10310092_pertness
adeptness1273953adeptness
apartness1146053apartness
averseness1345023averseness
averters11249513avert_ers
beeriness1137863beeriness
coverless1436803cover_less
covertnesses1746333covertnesses
curtness1037263_curtness
deftness1236303_deftness
eeriness8311873_eeriness
erectness1146123erectness
evenness1135543eve_nness
eventless1244603eventless
expertness1944823expertness
fieriness1238623fieriness
fleetness1244753fleetness
governessy1741853gover_nessy
greatness1036903greatness
ineptness1145073ineptness
inverness1247133inver_ness
leeriness938323leeriness
loveliness1345303loveliness
meetness1036653_meetness
modernness1343523modernness
neatness839153_neatness
obeseness1145893obeseness
oneness7512143one__ness
openness1035473ope_nness
orneriness1045443orneriness
otherness1245513other_ness
ovalness1134673ov_alness
overages12513833overage_s
overawes14511183overawe_s
overbets132510683over_bets
overclass1436963overclass
overdoers13117403overdoers
overdoes121212543overdoe_s
overdoses13119793overdoses
overdyers16125003overdyers
overdyes15127473overdye_s
overfeeds16226023overfeeds
overlends13237523overlends
overlets112312363over_lets
overlies112417043overlie_s
overmines14312683overmine_s
overnear11238473over_near
overneat112713643over_neat
overnew13268133over_ne_w
overpass13258653over_pass
overseas112612423over_seas
overseeds13248893overseeds
overseers12298783overseers
oversees112415903over_sees
oversets113114173over_sets
oversews14289423over_sews
oversteers1344863oversteers
oversteps1436303oversteps
overstrews1644473overstrews
overtakes16119823overtakes
overtalks1645663overtalks
overtask1535773overt_ask
overtasks1644593overtasks
overtaxes19118803overtaxes
overtimes141511303overtimes
overtips1338353overt_ips
overtires121412373overtires
overtoils1237083overtoils
overtone111012573overtone__
overtops1338513overt_ops
overtreat1249373overtreat
overtreats1346643overtreats
overtrims1447503overtrims
overtures121611453overtures
overturns12136623overturns
overuses11312643overuse_s
overviews1844283overviews
overweens15247003overweens
overwets14219953over_wets
peartness1137773peartness
poverties1439513povertie_s
severeness1346123severeness
shortness1236733shortness
smartness1136143smartness
soberness1186463sober_ness
sternness946093sternness
svelteness1344423svelteness
swartness1236113swartness
sweetness1245683sweetness
tartness82210133_tartness
vastness11257293_vastness
ventless11249053_ventless
verbless1336033_verbless
vestless11258843_vestless
wetness10277723_we_tness

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.313570897.8
2DLD Change Limit1486411047.33020278.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.68923239.8
 
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.