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

242 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
greatens930759(None) 
greaten83610641greaten_
creates95225202create_s
creatins103617512creatins
grabens10367002gr_abens
graters85419742gr_aters
grates75429892gr_ate_s
gratins84119182gr_atins
greasers93410252greasers
greases84816712grease_s
greatened1144582greatened
greater84416492greate_r
greatest939862greatest
greatness1036902greatness
greats76318392great__s
greaves113311442greave_s
greens75716872gre__ens
greeters92610112greeters
greisens954652greisens
greyhens1542632greyhens
neatens73310402_neatens
threatens1254672threatens
treaters83615842treaters
wheatens1454662wheatens
aerates74627493aerate_s
aretes64425353are_te_s
beaten84617063_beaten_
beaters94925043_beaters
berates94126873berate_s
bleaters103412323bleaters
brazens18418713br_azens
breakers143810973breakers
breathers14319103breathers
breathes134212903breathes
breaths124411183breat_hs
broadens11267243broadens
cerates95428253cerate_s
ceratins102818733ceratins
cheapens15305943cheapens
cheaters133613513cheaters
craters95021893cr_aters
crates85736063cr_ate_s
cratons94316033cr_atons
cravens124010123cr_avens
creamers124111313creamers
creasers103612843creasers
creases94020963crease_s
create85126383create__
created104323453create_d
creatin93618133creatin_
creatine103417413creatine
creatines112814433creatines
creating113921953creating
creations112614543creations
creators102814413creators
cremates124216003cremate_s
cretins93216423cre_tins
deadens93410693_deadens
deafens11317253_deafens
derates84028893derate_s
dreamers11369003dreamers
eaten55323053__eaten_
eaters65535953__eaters
erecters102611613erecters
ergates8314493ergate_s
fraters103517213fr_aters
freshens14298313freshens
fretters113410303fretters
galateas937143galateas
gaters74728643g__aters
gates65939513g__ate_s
gelates83219583gelate_s
gelatins93414093gelatins
gentes75324163g_ente_s
germens1078633g_ermens
gestes75721393g_este_s
getters84216103g_etters
gigatons1046053gigatons
gleamers11306563gleamers
gleaners9348073gleaners
gleans75014743glea__ns
glistens9366593glistens
gloaters9288863gloaters
glutens8437593g_lutens
goatees82710443g_oatees
graben9419723gr_aben_
graces94523493gr_ace_s
gradates10510783gradate_s
graders94716013gr_aders
grades84926313gr_ade_s
gradins93416233gr_adins
grafters12409193grafters
grains74223093gr_a_ins
grans64832543gr_a__ns
grantees92510973grantees
granters93614143granters
grapes95123123gr_ape_s
grate64932883gr_ate__
grated84523923gr_ate_d
grater74625443gr_ate_r
gratin74520583gr_atin_
gratine84719193gr_atine
grating93923183gr_ating
gratings103910763gr_atings
gratis74819243gr_at_is
gravamens1542783gravamens
gravels113611143gr_avels
graven104513523gr_aven_
gravers114515273gr_avers
graves104624003gr_ave_s
grazers175112453gr_azers
grazes164519643gr_aze_s
grease75416233grease__
greased93812393grease_d
greaser83913083grease_r
greasing102811393greasing
great66034243great___
greatening1245443greatening
greatly1137613great_ly
greave104611493greave__
greaved12408913greave_d
grebes93813613gre_be_s
greeds84314283gre__eds
green65522143gre__en_
greeny104811453gre__eny
grees65132473gre__e_s
greeted93111383greete_d
greeter82812673greete_r
greeting103112353greeting
greetings11276043greetings
greets75117423gre__ets
greiges937733greige_s
greisen856503greisen_
gremlins1136053gremlins
grenades1038433grenade_s
greyhen1443193greyhen_
greyness1235243greyness
grifters12389233grifters
gristers94013403gristers
gritters94210633gritters
groaners9248503groaners
groans74815063groa__ns
groats74816653groat__s
grouters95910083grouters
grunters9359033grunters
grutten885283grutten_
gyrates113610263gyrate_s
heartens113010153_heartens
heaters104225223_heaters
heathens143210153_heathens
heavens13439303_heavens
ideates8313733ideate_s
keratins122313483keratins
krakens1034293kr_akens
kraters114212343kr_aters
latens64620213__latens
leadens83610983_leadens
leavens10409303_leavens
neaten64214543_neaten_
oleates7417833oleate_s
orates64328613or_ate_s
patens84820863__patens
peahens12307573_peahens
pectens11189203_pectens
platens94213983_platens
pleaters103613793pleaters
praters94921653pr_aters
prates84633163pr_ate_s
prealters1147773prealters
preavers13910263preavers
predates11615813predate_s
preens85020113pre__ens
prelates10418573prelate_s
presters103419003presters
preteens1038123preteens
pretend104011013pre_tend
pretends11299113pre_tends
pretense10199823pre_tense
ratans63819373_r_atans
ratels64518213_r_atels
raters63936583_r_aters
rates55352013_r_ate_s
rattens74213403_rattens
ravens93916883_r_avens
readers83823773_readers
reagent8716603_reagent
reagents959623_reagents
reagins84215643_reagins
reales64934123_reale_s
realters83614043_realters
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
reasons72514943_reasons
reatas64021013_reat_as
reavers108320743_reavers
reaves94127573_reave_s
rebaters103413943_rebaters
rebates95123183_rebate_s
redates83423873_redate_s
reddens9259783_reddens
refastens1244753_refastens
relaters83218153_relaters
relates73731433_relate_s
remates93827113_remate_s
renters74224813_renters
rentes65431193_rente_s
reopens939373_reopens
resters74130403_resters
retains74522253_retains
retems83914573_re_tems
retene69224273_re_tene
retenes76324623_re_tenes
rewakens15406243_rewakens
seaters74028943_seaters
sweaters113811063sweaters
sweetens11255433sweetens
theaters114211903theaters
threaten1146303threaten_
treaders93311843treaders
treasons848683treasons
treated83618703treate_d
treater74219833treate_r
treaties8316983treaties
treating92519613treating
treatment1148183treatment
treatments1246283treatments
treats64821693treat__s
treens65317873tre__ens
uneaten7412543uneaten_
urates65027763ur_ate_s
ureases74416723urease_s
ureters7311823ure_ters
weakens14367063_weakens
wheaten1336403wheaten_
wreakers15328423wreakers
wreathen14256143wreathen_
wreathers15257493wreathers
wreathes14299893wreathes
wreaths13338373wreat_hs
wresters112711733wresters
zeatins16311733_zeatins

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.423422437.4
2DLD Change Limit1461622426.57622226.6
3Display Results2422420.1102200.0
 (SQL Overall)1786912427.10925135.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.