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

55 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
dopeyness154347(None) 
doneness9411512done_ness
dopeynesses1744022dopeynesses
dopiness11289972dop_iness
gooeyness1343542gooeyness
hokeyness1943802hokeyness
homeyness1745022homeyness
openness1035472_openness
cageyness1543483cageyness
coyness1277323co__yness
dailyness1343643dailyness
dapperness1543153dapperness
datedness1187753datedness
dazedness20114963dazedness
deepness1136443d_eepness
dippiness1435973dippiness
direness9311303dire_ness
dodginess1235283dodginess
doggedness1443513doggedness
dopesters1237283dopesters
dorkiness14248053dorkiness
dottiness1058043dottiness
dourness947683do_urness
dowdiness1485693dowdiness
dowerless1344013dowerless
downiness13106713downiness
doyennes1244363doyenne_s
doziness18228553do_ziness
dryness11114783d__ryness
dueness82310123d_ue_ness
feyness1334923__feyness
glueyness1342913glueyness
goneness9310763gone_ness
governess1346173governess
greyness1235243_greyness
hopeless13118303hope_less
loneness8512093lone_ness
mateyness1444473mateyness
moneyless1444653moneyless
mopiness12259063mop_iness
moreness10911573more_ness
notedness1047323notedness
oneness7512143_one_ness
openers9339493_ope_ners
openest9312913_ope_nest
popeless1288473pope_less
properness1445923properness
ripeness1039363ripe_ness
ropiness102311073rop_iness
soberness1186463soberness
soleness8814263sole_ness
soppiness1336543soppiness
soreness8914793sore_ness
spryness1334003_spryness
woeness1020211543wo_e_ness

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.406440125.6
2DLD Change Limit148641557.20320636.0
3Display Results55550.0301833.3
 (SQL Overall)178691557.63923391.9
 
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.