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

369 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
dreamers1136900(None) 
creamers124111311creamers
dreamer104110841dreamer_
reamers94221081_reamers
breakers143810972breakers
creamer113714092creamer_
creamery15385982creamery
creasers103612842creasers
dealers84118612d_ealers
defamers14258522defamers
drapers105313352dr_apers
drawers113610072dr_awers
dreamed114310632dreame_d
dreamier11287292dreamier_
dreamless1243512dreamless
dreams94513982dream__s
drears74614252drea__rs
dredgers11256092dredgers
dressers9359862dressers
drummers13316162drummers
framers125113822fr_amers
gleamers11306562gleamers
greasers93410252greasers
preavers13910262preavers
readers83823772_readers
reamer84325212_reamer_
reapers93520452_reapers
rearers74323562_rearers
reavers108320742_reavers
roamers93713462_roamers
screamers13236262screamers
seamers94719432_seamers
steamers103410872steamers
streamers11228072streamers
treaders93311842treaders
treaters83615842treaters
wreakers15328422wreakers
arames84622573ar_ame_s
armers85520273ar__mers
arrayers11125853arrayers
beaders104120183_beaders
beakers134216873_beakers
bearers94619593_bearers
beaters94925043_beaters
beavers124417323_beavers
bereavers1446123bereavers
blamers115314213_blamers
bleaters103412323bleaters
bracers114616703br_acers
bravers124715523br_avers
brayers124511903br_ayers
brazers184513943br_azers
breachers16369853breachers
breaker133912923breaker_
breamed124011593breame_d
breams104815043bream__s
breathers14319103breathers
breeders11368893breeders
breviers1335923breviers
brewers123811063bre_wers
brimmers14287073brimmers
cheaters133613513cheaters
cleaners103610543cleaners
clearers10349303clearers
cleavers13398873cleavers
crammers14369353crammers
craters95021893cr_aters
cravers124416563cr_avers
creamed123913713creame_d
creameries1446673creameries
creamier12319063creamier_
creams104715253cream__s
creaser94415743creaser_
creases94020963crease_s
creates95225203create_s
creators102814413creators
creepers12318633creepers
cremes104517993cre_me_s
crimmers14298543crimmers
croakers14288523croakers
damagers1237073damagers
damars93815003d__amars
dames85435853d__ame_s
dammers123214273d_ammers
damners104112113d__amners
dampers123915693d__ampers
darers75921873d__arers
daters74827373d__aters
daydreamers1851333daydreamers
deadens93410693d_eadens
deader84220473d_eader_
deafens11317253d_eafens
deafer104114813d_eafer_
deairs74013783d_ea_irs
dealer74122143d_ealer_
deanery1137613d_eanery
dearer74822803d_earer_
dears65736883d_ea__rs
deaves105319533d_eave_s
debasers11377903debasers
debaters113511923debaters
decayers14307963decayers
deckers144413833d_eckers
deers64930523d_e__ers
defacers14237993defacers
defamer132710323defamer_
defames132812253defame_s
defeaters13289103defeaters
defers105116943d_e_fers
defiers113913993d_efiers
defoamers15285253defoamers
degames113312623degame_s
degreasers1243143degreasers
deicers103612733d_eicers
delayers12268663delayers
delvers113411993d_elvers
demes86032693d_e_me_s
demurs939773d_e_murs
deniers84515183d_eniers
derangers1136703derangers
derates84028893derate_s
deriders102411853deriders
derivers123811363derivers
deters74724683d_e_ters
dewaters122910723dewaters
dialers83614303d_ialers
diapers104713913d_iapers
diemakers1645263diemakers
diesters92513603diesters
dieters83216433die_ters
diethers1257453diethers
dilaters92513063dilaters
dimers94321093d__imers
dimmers123811563d_immers
disarmers1246943disarmers
dormers104313923d_ormers
dowagers1334893dowagers
drafters12338533drafters
dragees9359483dr_agees
draggers11357393draggers
drainers92811253drainers
drakes114715863dr_ake_s
dramas95814663dr_am_as
dramedy1433243dr_amedy
drams86025833dr_am__s
draper94315693dr_aper_
drapery13387943dr_apery
drapes95419653dr_ape_s
drawees11378363dr_awees
drawer104711363dr_awer_
drawlers12307313drawlers
dreaded103612023dreade_d
dreads84115023drea__ds
dream85120393dream___
dreamful1452963dreamful
dreamiest12227223dreamiest
dreamily1435143dreamily
dreaminess1345313dreaminess
dreaming124011063dreaming
dreamt94615713dream__t
dreamy12509993dream__y
drear65016903drea__r_
drearier9297923drearier_
drearies92313413drearies
dreary104611673drea__ry
dredger10347453dredger_
dredges10379353dredge_s
drees65628523dre__e_s
dreidels1033213dreidels
drenchers15296103drenchers
dresser83611953dresser_
dresses83716173dresse_s
driers74516733dr__iers
drifters12417913drifters
drillers9429723drillers
drinkers13277823drinkers
drippers13327943drippers
drivers114412793dr_ivers
droners84114383dr_oners
droppers13318603droppers
drovers115212643dr_overs
drowners12428273drowners
drubbers13386033drubbers
drudgers11326853drudgers
drummer12407503drummer_
druthers1275793druthers
dryades12395633dryade_s
dryers10449273dr__yers
duelers83412053due_lers
duellers9268223duellers
duramens1195153duramens
dwellers12356083dwellers
eagers74523683__eagers
eaters65535953__eaters
emmers104013223__emmers
erasers74413943er_asers
erecters102611613erecters
fearers104815273_fearers
flamers124616363_flamers
foamers123812103_foamers
framer114817443fr_amer_
frames115119863fr_ame_s
fraters103517213fr_aters
freers94717303fre__ers
freezers20307173freezers
fretters113410303fretters
gamers94420833__gamers
gleamer10328513gleamer_
gleaners9348073gleaners
graders94716013gr_aders
graters85419743gr_aters
gravers114515273gr_avers
grazers175112453gr_azers
greaser83913083greaser_
greases84816713grease_s
greatens9307593greatens
greater84416493greater_
greaves113311443greave_s
greeters92610113greeters
groaners9248503groaners
groomers11388483groomers
headers113819393_headers
healers104319463_healers
heapers123616673_heapers
hearers104319783_hearers
heaters104225223_heaters
heavers133717193_heavers
hemmers143310843_hemmers
klezmers2341583klezmers
kneaders1384713kneaders
kraters114212343kr_aters
kreuzers2132063kreuzers
krimmers16315673krimmers
leaders83819603_leaders
leakers113415423_leakers
leaners73718173_leaners
leapers93716663_leapers
leasers74717843_leasers
leavers103717783_leavers
meaners94415243_meaners
metamers1249623metamers
namers84517333__namers
ormers84316143or__mers
phreakers1834673phreakers
pleaders113210183pleaders
pleasers104010293pleasers
pleaters103613793pleaters
praters94921653pr_aters
prayers124212853pr_ayers
preachers16339573preachers
prealters1147773prealters
preamps1336613pream_ps
preaver121011613preaver_
preeners102712813preeners
prefacers1636293prefacers
prefers123713333pre_fers
pregames1339003pregame_s
preggers12236833preggers
premeds12389593pre_meds
premiers122911653premiers
prenames12311643prename_s
preparers13197673preparers
presagers1236943presagers
pressers103215023pressers
presters103419003presters
presumers1336373presumers
preyers124412363pre_yers
primers114215673pr_imers
racers84725433_r_acers
rakers104123573_r_akers
ramees84620893_r_amees
ramets83517393_r_amets
rammers113715043_rammers
rapers84327183_r_apers
rasers64526783_r_asers
raters63936583_r_aters
ravers94628183_r_avers
razers154919613_r_azers
reachers133515723_reachers
reader73628293_reader_
realer63528593_realer_
reales64934123_reale_s
realters83614043_realters
reamed94326123_reame_d
reams75729623_ream__s
reaper84223143_reaper_
rearer64928913_rearer_
rears54739653_rea__rs
reaver94524733_reaver_
reaves94127573_reave_s
rebaters103413943_rebaters
recamiers1345513_recamiers
redders93615343_redders
reefers103312593_reefers
reekers113613143_reekers
reelers73520273_reelers
refers93921083_re_fers
regalers94311133_regalers
rehammers1644503_rehammers
reivers105117083_reivers
relaters83218153_relaters
relaxers15298263_relaxers
reliers75519213_reliers
remakers143811303_remakers
renames92418053_rename_s
renders83821673_renders
renters74224813_renters
repapers1258833_repapers
resters74130403_resters
resumers1038083_resumers
retakers123511133_retakers
revampers1653443_revampers
revers94529633_re_vers
rhymers15365543_rhymers
rimers84522553_r_imers
rimmers113812883_rimmers
roamer84715163_roamer_
roarers73812743_roarers
roomers95416413_roomers
rummers113513653_rummers
screamer12267883screamer_
sealers74323553_sealers
seamer84223613_seamer_
seaters74028943_seaters
seemers93814333_seemers
shearers113911323shearers
smearers10308623smearers
sneakers12308643sneakers
speakers14299453speakers
spearers103711143spearers
spreaders1236503spreaders
stealers83412213stealers
steamer93313093steamer_
stemmers12378443stemmers
streakers13218133streakers
streamer10239513streamer_
surnamers1143803surnamers
swearers11328583swearers
sweaters113811063sweaters
tamers84224033__tamers
tearers75218233_tearers
teasers75317243_teasers
teemers95012903_teemers
termers95414503_termers
theaters114211903theaters
threaders1365743threaders
threapers1444773threapers
tracers94917843tr_acers
traders84316953tr_aders
tramels93812493tr_amels
trampers123210393tr_ampers
treader84113833treader_
treadlers1045893treadlers
treater74219833treater_
trekkers1133803trekkers
tremors93711233tre_mors
trimers94615143tr_imers
trimmers12288913trimmers
ureases74416723urease_s
ureters7311823ure_ters
vealers103214293_vealers
vitamers1334683vitamers
weaners104613833_weaners
wearers104615903_wearers
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.423422437.4
2DLD Change Limit1461623698.00018270.3
3Display Results3693690.1402635.7
 (SQL Overall)1786913698.56320867.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.