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

407 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
greasers9341025(None) 
creasers103612841creasers
greaser83913081greaser_
greases84816711grease_s
breakers143810972breakers
creamers124111312creamers
creaser94415742creaser_
creases94020962crease_s
degreasers1243142degreasers
dreamers11369002dreamers
dressers9359862dressers
erasers74413942er_asers
geysers1135702g_eysers
gleamers11306562gleamers
gleaners9348072gleaners
graders94716012gr_aders
graspers11338402gr_aspers
graters85419742gr_aters
gravers114515272gr_avers
grazers175112452gr_azers
grease75416232grease__
greased93812392grease_d
greasier9298082greasier_
greatens9307592greatens
greater84416492greater_
greaves113311442greave_s
greeters92610122greeters
greisens954652greisens
groaners9248512groaners
grossers94410972grossers
grousers93810732grousers
guessers9174902guessers
leasers74717842_leasers
pleasers104010292pleasers
preavers13910262preavers
pressers103215022pressers
rasers64526782_r_asers
readers83823772_readers
reamers94221082_reamers
reapers93520452_reapers
rearers74323562_rearers
reavers108320742_reavers
teasers75317242_teasers
treaders93311842treaders
treaters83615852treaters
ureases74416722urease_s
wreakers15328422wreakers
abasers95311973_abasers
appeasers1345263appeasers
arousers84810983arousers
arrases71214543arrase_s
arrayers11125853arrayers
beaders104120183_beaders
beakers134216873_beakers
bearers94619593_bearers
beaters94925043_beaters
beavers124417323_beavers
bereavers1446123bereavers
bleaters103412323bleaters
blessers10277633blessers
boreases10310253borease_s
bracers114616703br_acers
brasiers103710513br_asiers
bravers124715523br_avers
brayers124511903br_ayers
brazers184513943br_azers
breachers16369853breachers
breaker133912923breaker_
breasts939703breas_ts
breathers14319103breathers
breeders11368893breeders
breviers1335933breviers
brewers123811063bre_wers
browsers13449203browsers
bruisers10307953bruisers
caressers1137443caressers
ceases84427073_cease_s
censers94313903_censers
chasers123714923_chasers
cheaters133613513cheaters
cleaners103610543cleaners
cleansers11335073cleansers
clearers10349303clearers
cleavers13398873cleavers
crases85532313cr_ase_s
crashers134013233cr_ashers
craters95021893cr_aters
cravers124416563cr_avers
creamer113714093creamer_
creamery15385983creamery
crease85519573crease__
creased104315593crease_d
creasier103210203creasier_
creates95225203create_s
creators102814413creators
creepers12318633creepers
creeses93914623creese_s
cresses94219813cresse_s
cressets10309103cressets
croakers14288523croakers
crossers103912713crossers
cruisers10438283cruisers
dealers84118613_dealers
debasers11377903debasers
degreaser1144333degreaser_
degreases1146153degrease_s
drapers105313353dr_apers
drawers113610073dr_awers
dreamer104110843dreamer_
drears74614253drea__rs
dredgers11256093dredgers
dresser83611953dresser_
dresses83716173dresse_s
eagers74523683__eagers
easels65914553__easels
eases56041613__ease_s
easters75125683__easters
eaters65535953__eaters
egresses949443egresse_s
eraser64216333er_aser_
erases64425403er_ase_s
erecters102611613erecters
fearers104815273_fearers
feases95422923_fease_s
feasters11511563_feasters
flensers1135463flensers
framers125113823fr_amers
fraters103517213fr_aters
freebasers1543003freebasers
freers94717303fre__ers
freezers20307173freezers
fretters113410303fretters
gagers84021333g__agers
gamers94420833g__amers
gapers94520473g__apers
gases65633993g__ase_s
gaspers105014133g__aspers
gassers84714633g_assers
gasters85624303g__asters
gaters74728643g__aters
gazers164516303g__azers
gears64628693g_ea__rs
geezers17286513g_eezers
gelders93812573g_elders
genders93616783g_enders
getters84216103g_etters
geyser1036513g_eyser_
glazers174410043g_lazers
gleamer10328513gleamer_
gleaner8379773gleaner_
gloaters9288863gloaters
glossers9319053glossers
gnawers11356393g_nawers
grabbers13337883grabbers
grabens10367003gr_abens
graces94523493gr_ace_s
grader84919693gr_ader_
grades84926313gr_ade_s
grafters12409193grafters
grainers93012083grainers
grangers103011973grangers
granters93614153granters
grapery13457953gr_apery
grapes95123123gr_ape_s
grasper10389793gr_asper_
grasps9489253gr_as_ps
grass66125203gr_as__s
grasses84117343gr_asses
grater74625443gr_ater_
grates75429893gr_ate_s
gravels113611143gr_avels
graver105018593gr_aver_
graves104624003gr_ave_s
grayer106014543gr_ayer_
grazer164815763gr_azer_
grazes164519643gr_aze_s
graziers18387123graziers
greaseless1143483greaseless
greasiest10208563greasiest
greasily1236233greasily
greasiness1156563greasiness
greasing102811393greasing
greasy10419463greas__y
greaten83610643greate_n
greatest939863greatest
greatness1036903greatness
greats76318393grea__ts
greave104611493greave__
greaved12408913greave_d
grebes93813613gre_be_s
greeds84314283gre__eds
greener83111713greener_
greenery12265923greenery
greens75716873gre__ens
grees65132473gre__e_s
greeter82812673greeter_
greets75117423gre__ets
greiges937733greige_s
greisen856503greise_n
grenades1038433grenade_s
grenadiers1242593grenadiers
greyer104510093gre_yer_
greyhens1542633greyhens
greyness1235243greyness
gridders11286293gridders
grievers1255473grievers
grifters12389233grifters
grillers93810813grillers
grilses8319153grilse_s
grimacers1463553grimacers
grinders103410423grinders
grinners9288043grinners
gripers104011463gr_ipers
grippers13358133grippers
gristers94013413gristers
gritters94210633gritters
groaner82510133groaner_
grocers103511253gr_ocers
groomers11388483groomers
groovers12337123groovers
gropers104813853gr_opers
grosser84313143grosser_
grosses84517683grosse_s
groupers11358643groupers
grouser84513693grouser_
grouses84616543grouse_s
grouters95910093grouters
growers113612723gr_owers
growlers12327093growlers
grubbers13316203grubbers
grudgers11266753grudgers
gruelers936173gruelers
gruellers1034183gruellers
grungers10298503grungers
grunters9359043grunters
guesser8166543guesser_
guesses8169373guesse_s
gyrases11368313gyrase_s
headers113819393_headers
healers104319463_healers
heapers123616673_heapers
hearers104319783_hearers
heaters104225223_heaters
heavers133717193_heavers
increasers1243313increasers
kneaders1384713kneaders
kraters114212343kr_aters
kreuzers2132063kreuzers
lasers64925703__lasers
leaders83819603_leaders
leakers113415423_leakers
leaners73718173_leaners
leapers93716663_leapers
leaser65322673_leaser_
leases65428113_lease_s
leavers103717783_leavers
masers84623453__masers
meaners94415243_meaners
ogresses938473ogresse_s
oleasters936733oleasters
peases85229473_pease_s
perusers10328803perusers
phreakers1834673phreakers
pleaders113210193pleaders
pleaser93912343pleaser_
pleases94515483please_s
pleaters103613793pleaters
praisers103410843praisers
prases84429023pr_ase_s
praters94921653pr_aters
prayers124212853pr_ayers
preachers16339573preachers
prealters1147773prealters
preaver121011613preaver_
preeners102712813preeners
prefacers1636293prefacers
prefers123713333pre_fers
preggers12236833preggers
premiers122911653premiers
preparers13197673preparers
presagers1236943presagers
presets94216423pre_sets
presser93717623presser_
presses93523153presse_s
pressors103212693pressors
presters103419003presters
preyers124412363pre_yers
prosers94219643pr_osers
racers84725433_r_acers
raisers73617393_raisers
rakers104123573_r_akers
rapers84327183_r_apers
raser55633413_r_aser_
rases55447213_r_ase_s
rashers104020913_r_ashers
raspers94415923_r_aspers
rasters74629023_r_asters
raters63936583_r_aters
ravers94628183_r_avers
razers154919613_r_azers
reachers133515723_reachers
reader73628293_reader_
realer63528593_realer_
reales64934123_reale_s
realisers9248323_realisers
realters83614043_realters
reamer84325213_reamer_
reaper84223143_reaper_
rearer64928913_rearer_
rears54739653_rea__rs
reasoners947113_reasoners
reasons72514943_reasons
reassert8313673_reassert
reasserts945983_reasserts
reassess836513_reassess
reaver94524733_reaver_
reaves94127573_reave_s
rebaters103413943_rebaters
redders93615343_redders
reefers103312593_reefers
reekers113613143_reekers
reelers73520273_reelers
refers93921083_re_fers
refusers11499273_refusers
regalers94311133_regalers
reivers105117083_reivers
relapsers1164123_relapsers
relaters83218153_relaters
relaxers15298263_relaxers
releasers937323releasers
reliers75519213_reliers
remakers143811303_remakers
remasters11310583_remasters
renders83821673_renders
renters74224823_renters
repapers1258833_repapers
reposers102911603_reposers
resees63827483_re_sees
resets65427613_re_sets
resews94814173_re_sews
resters74130403_resters
retakers123511133_retakers
reuses66025523_reuse_s
revers94529633_re_vers
revisers113511933_revisers
rinsers73815743_rinsers
risers64624783_r_isers
roamers93713463_roamers
roarers73812743_roarers
roasters83615933_roasters
roosers74217883_roosers
rousers75220143_rousers
screamers13236263screamers
sealers74323553_sealers
seamers94719433_seamers
seaters74028943_seaters
seisers73816393_seisers
shearers113911323shearers
smearers10308623smearers
sneakers12308643sneakers
speakers14299453speakers
spearers103711143spearers
spreaders1236503spreaders
stealers83412213stealers
steamers103410873steamers
streakers13218143streakers
streamers11228083streamers
swearers11328583swearers
sweaters113811063sweaters
tearers75218233_tearers
teasels74311313_teasels
teaser65421523_teaser_
teases65426273_tease_s
theaters114211903theaters
threaders1365743threaders
threapers1444773threapers
tracers94917843tr_acers
traders84316953tr_aders
trashers113013643tr_ashers
treader84113833treader_
treadlers1045893treadlers
treasons848683treasons
treasure846753treasure
treasurers1043203treasurers
treasures946633treasures
treasury1143793treasury
treater74219833treater_
trekkers1133803trekkers
tressels8367653tressels
tresses73719543tresse_s
trousers83910633trousers
trowsers11428003trowsers
trussers8348283trussers
uneases73316263unease_s
urases63723563ur_ase_s
urease64516993urease__
ureters7311823ure_ters
vealers103214293_vealers
versers103813523_versers
weaners104613833_weaners
wearers104615903_wearers
weasels10468503_weasels
weavers133714463_weavers
wreaker143610043wreaker_
wreathers15257493wreathers
wreckers17315973wreckers
wresters112711733wresters

Search took 9 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.420425454.8
2DLD Change Limit1461624077.59619242.0
3Display Results4074070.1702394.1
 (SQL Overall)1786914078.18621828.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.