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

251 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
greenies931267(None) 
greenie8310121greenie_
greenier938711greenier
greeniest1039031greeniest
creepies1239612creepies
freebies1337872freebies
genies75324942g__enies
grannies9312612grannies
greedier1036082greedier
greediest1147552greediest
greened93111262green_ed
greener83111712green_er
greeneries1167072greeneries
greenest9312622green_est
greenflies1443582greenflies
greening103112532greening
greenings11266662greenings
greenish1247082greenish
greenlet948512greenlet
greenlets1044702greenlets
greenness1046792greenness
greens75716872green__s
greenths1295212greenths
gremmies1355992gremmies
preemies12512192preemies
redenies9615712_redenies
sheenies111411542sheenies
sweenies11148762sweenies
tweenies11146392tweenies
weenies102915092_weenies
ardencies1247853ardencies
arenes64928393ar_en_es
arenites8917103ar_enites
arsenics1056763arsenics
arsenides1095613arsenides
arsenites9149163arsenites
arteries8321483arteries
beanies93821093_beanies
beedies10314203_beedies
bennies93917313_bennies
blennies1056933blennies
breeches15258673breeches
breezes18318693bree_zes
breezier1934533breezier
breeziest2035063breeziest
breweries1447583breweries
brinies93317913br_inies
brionies10310543brionies
brownies13189613brownies
bryonies1336843bryonies
crannies10313013crannies
credences1498143credences
creepie1137483creepie_
creepier1236253creepier
creepiest1337063creepiest
creeses93914623cree_ses
creeshes1336953creeshes
cronies9622503cr_onies
denies74729643__denies
drearies92313413drearies
freebees1345353freebees
freebie1236043freebie_
freeness11710443freeness
freesias1146333freesias
freezes193310353free_zes
frenzies2037713frenzies
gaieties9310183gaieties
galenites10129183galenites
gardenias1145403gardenias
gayeties1236883gayeties
geekier12286393g_eekier
geekiest13257873g_eekiest
genes65133093g__en_es
geneses82613523g_eneses
genie66124923g__enie_
genips9469943g__enips
genius74512923g__enius
genres75515623g__enres
gentes75324163g__entes
gerents82612923geren_ts
gerenuks1342563gerenuks
gleetier934913gleetier
gleetiest1035913gleetiest
goonies83618333g_oonies
gradines103615253gradines
graecizes2144573graecizes
grainier9218903grainier
grainiest10188993grainiest
granges93516523gr_anges
granites92116363gr_anites
grannie8310353grannie_
graperies1239613graperies
gravies11314093gr_avies
greases84816713gr_eases
greasier9298083greasier
greasiest10208563greasiest
greaves113311443gr_eaves
grebes93813613gr_e_bes
grecizes2035683grecizes
greedily1345183greedily
greediness1245833greediness
greedless1144893greedless
greeds84314283gree__ds
greegree1044483greegree
greegrees1142853greegrees
greeing93613783gree_ing
green65522143green___
greenbelt1243973greenbelt
greenbelts1352453greenbelts
greenbrier1352853greenbrier
greenbriers1452263greenbriers
greenbug1242633greenbug
greenbugs1342503greenbugs
greenery12265923greenery
greenfield1552153greenfield
greenfields1651553greenfields
greenfly1554083greenfly
greengages1343403greengages
greenhead1443163greenhead
greenheads1542993greenheads
greenling1136753greenling
greenlings1243593greenlings
greenlit945803greenlit
greenly11408193green_ly
greenmails1382783greenmails
greensick1642873greensick
greenth11116723green_th
greenwash1642403greenwash
greenway1543853greenway
greenways1643433greenways
greenwing1434693greenwing
greenwings1542703greenwings
greeny104811453green__y
grees65132473gr_e__es
greeted93111383gree_ted
greeter82812673gree_ter
greeters92610113greeters
greeting103112353greeting
greetings11276043greetings
greets75117423gree__ts
greiges937733gr_eiges
gremlins1136053gremlins
gremmie1264383gremmie_
grenades1038433grenades
greyness1235243greyness
grieves1137323grie_ves
groceries1249503groceries
groupies1137523groupies
groynes1137823groyn_es
grunges93310403gr_unges
gunnies83413123g_unnies
gyrenes11267523gyren_es
heinies102514543_heinies
heresies11312693heresies
irenics937833ir_enics
ironies7517423ir_onies
jennies143511623_jennies
kneesies1245543kneesies
larcenies1147533larcenies
meanies93620743_meanies
meinies92516073_meinies
oogenies9311583oogenies
orogenies10410533orogenies
orreries8310123orreries
peeries93623023_peeries
pennies94218813_pennies
peonies93620153_peonies
predries112714383predries
preedits1168763preedits
preemie11310563preemie_
preened103214993preen_ed
preener93114833preen_er
preeners102712813preeners
preening113115843preening
preens85020113preen__s
premies113823063pr_emies
preppies1149683preppies
presences132113793presences
pretences132312613pretences
pretenses112210593pretenses
pretties10615133pretties
preunites1138933preunites
prexies163415003pr_exies
progenies12314123progenies
readies83324713_readies
recencies13312253_recencies
redefies12710163_redefies
redenied10511283_redenied
redries83721713_redries
reedier83815303_reedier
reediest92815423_reediest
reedits8511743_reedits
reefier102912553_reefier
reefiest112811483_reefiest
reekier113111123_reekier
reekiest122711313_reekiest
reemits9611303_reemits
reenter73217793_reenter
reenters82915303_reenters
reentries9311763_reentries
reeves94721493_ree_ves
refences13311843_refences
refines105426343_refines
reflies104418533_reflies
refries104419733_refries
regencies1249283_regencies
reifies104218283_reifies
reknits1137073_reknits
relies65036423_r_elies
relines75331323_relines
remedies11310553_remedies
reneges82513593_reneges
renigs74314593_r_enigs
renins64526453_r_enins
rennins74013413_rennins
rentes65431193_r_entes
repines94927383_repines
replies94521043_replies
retenes76324623_reten_es
reties65436193_r_eties
retines75134673_retines
retries74129073_retries
reunites8312473_reunites
revenges1238983_revenges
revenues1138663_revenues
reveries112518513_reveries
rexines144719153_rexines
serenes73222903seren_es
sheenie10159493sheenie_
sheenier11167423sheenier
sheeniest12158353sheeniest
steelies8312553steelies
sweeties11159723sweeties
teenier72611143_teenier
teeniest82112413_teeniest
tennies73017973_tennies
trannies8415013trannies
treaties8316983treaties
treenails945563treenails
treens65317873treen__s
trendies9312213trendies
trienes74118413trien_es
trientes82812123trientes
urgencies1256643urgencies
veeries102916893_veeries
weenie92612023_weenie_
weenier103210803_weenier
weeniest112411213_weeniest
weepies122811743_weepies
wheelies1437863wheelies
wienies102213683_wienies

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622517.37319824.0
3Display Results2512510.1102281.8
 (SQL Overall)1786912517.91922564.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.