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

142 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
geekiness143541(None) 
beefiness1435582beefiness
beeriness1137862beeriness
cheekiness1944042cheekiness
eeriness8311872_eeriness
gawkiness1734752gawkiness
geekiest13257862geeki_est
geekinesses1635812geekinesses
gemminess1464632gemminess
germiness1257692germiness
greediness1245832greediness
jerkiness20175642jerkiness
leakiness1337502leakiness
leeriness938322leeriness
meekness1434302meek_ness
neediness10227732neediness
perkiness15209162perkiness
peskiness15216522peskiness
reediness10239612reediness
seediness10219172seediness
weediness13247042weediness
weepiness14215962weepiness
balkiness1556903balkiness
beadiness12249233beadiness
beelines103312803beeline_s
boskiness15196513boskiness
breeziness2143513breeziness
bulkiness1555933bulkiness
cakiness1449553_cakiness
cheeriness1545533cheeriness
cheesiness1544733cheesiness
chewiness1744823chewiness
cockiness17248783cockiness
corkiness152810443corkiness
creakiness1645963creakiness
creepiness1444883creepiness
deepness1136443dee_pness
dewiness1238453_dewiness
dorkiness14248053dorkiness
duskiness14216683duskiness
easiness8313043_easiness
edginess1036053_edginess
fieriness1238623fieriness
flakiness1636473flakiness
flukiness1635453flukiness
forkiness16268703forkiness
freakiness1745183freakiness
funkiness16226873funkiness
gabbiness1434403gabbiness
gaminess112911063g_aminess
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
geekier12286393geeki_e_r
gelidness1144473gelidness
genericness1472903genericness
giddiness1234683giddiness
glariness1038553glariness
glaziness1935753glaziness
glegness1034613gle_gness
gluiness937363g_luiness
godliness1136593godliness
goofiness1365603goofiness
goriness9310753g_oriness
goutiness1038763goutiness
grapiness1238253grapiness
greasiness1156543greasiness
greatness1036903greatness
greenness1046793greenness
greyness1235243gre_yness
griminess1236703griminess
gumminess1454973gumminess
gushiness13206853gushiness
gustiness10189893gustiness
gutsiness10226963gutsiness
headiness132510363headiness
heaviness15207063heaviness
heftiness1536313heftiness
hokiness152510183_hokiness
huskiness16206583huskiness
ickiness1436753_ickiness
inkiness1238693_inkiness
jettiness1675693jettiness
jokiness19227393_jokiness
keenness1234883kee_nness
kinkiness1235763kinkiness
kookiness1235563kookiness
lankiness1338053lankiness
larkiness1338113larkiness
leafiness1236483leafiness
legginess1135033legginess
luckiness1596573luckiness
mealiness11310063mealiness
meatiness11311183meatiness
meetness1036653mee_tness
merriness1138293merriness
messiness11248223messiness
milkiness1536523milkiness
murkiness15206293murkiness
muskiness15237443muskiness
nerdiness10208333nerdiness
nerviness12226873nerviness
newsiness1236033newsiness
pawkiness1835443pawkiness
peppiness1235183peppiness
pettiness1178703pettiness
pickiness1737623pickiness
pokiness14219863_pokiness
porkiness15249193porkiness
punkiness15226983punkiness
quakiness2236073quakiness
readiness102611853readiness
reekiest122711313reeki_est
riskiness1336963riskiness
rockiness15237833rockiness
seaminess11310473seaminess
seemliness1244153seemliness
sexiness1537943_sexiness
shakiness1637083shakiness
silkiness1337253silkiness
sleekness1344543sleek_ness
sleepiness1245133sleepiness
smokiness1535543smokiness
snakiness1367473snakiness
sneakiness1454873sneakiness
speediness1345223speediness
spikiness1536313spikiness
steeliness1046793steeliness
sulkiness1347353sulkiness
tackiness1557693tackiness
talkiness1356913talkiness
teariness9310633teariness
telekineses1562743telekineses
telekinesis1572183telekinesis
testiness9209753testiness
tweediness1443173tweediness
wackiness1836523wackiness
weakliness1753853weakliness
weakness1535353weak_ness
weariness1238843weariness
wheeziness2542543wheeziness
yuckiness1874923yuckiness

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.1731032896.0
2DLD Change Limit1486411426.89021573.4
3Display Results1421420.0801775.0
 (SQL Overall)1786911427.14325016.2
 
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.